DSXchange

Looks like a remove duplicates logic to me. Do you want to remove all the duplicates from the data? Then use a Remove Duplicates stage instead of a filter stage. Hash partition and sort the data on the key fields.

The documentation on DSRunJob subroutine in help topics is good. Read that first. Come up with a logic/flow for your routine. Then ask for suggestions.

On a temporary basis, yes. Datasets. That will be stored in DataStage internal format, in the resource disc. They are the most efficient way in terms of space, read/write efficiency to store data. You also have hashed files, file sets and sequential files.

What is the Data type of your input and output fields? And Why use stage variables? A simple derivation like would do. This will work only if the data type is char or Varchar. Only then would you be able to substitute the value N.

Check the nullability of your target fields. Post the derivations here. Are you trying to substitute N for a NULL, or are you just checking for null and populating the Flag field to N?

From your examples i would assume that the input is always 8 characters long. So a simple substring like In.Col[5,2] in a transformer stage would do.

For every record you need to find the difference between the fields Historic and All Channel and populate a third field with this value. Is this understanding correct? If so then you can do it in a transformer stage. Create a field say VAR and in the derivation say All Channel - Historic.

You already have a post on this issue here.

viewtopic.php?t=116399

Why start a new tread for the same issue?

Think you will have to specify a length for each of these fields. Do a search on "Max length must be positive".

Think you will have to specify a length for each of these fields. Do a search on "Max length must be positive".

Try this. If the input is black or just a space then you should be comparing the output of the trim() with ""(empty). if stgFICODOMSUBIND=2 then if trim(lnkCIIOut.RE_CGSB_SCR_2)="" Or IsNull(lnkCIIOut.RE_CGSB_SCR_2) then stringtodecimal("-9999") else stringtodecimal(lnk...

There is no direct of the shelf tool. Buy the license for PX. Install it. Test to see if it is up and running. See if the server job logic can be mirrored in PX. Code it. Test it.

Yes.

You can join. your key columns should have the same name. Identify the key fields in both the links. Keep the key field names in one of the link same and change the field names for the other link. Then you will see that the drop down is populated. Select the fields from the drop down. Do the renamin...

I think you will need to escape even the = character. I had a problem with that once. it is considered as a delimiter or something and it would stop at the = character.