DSXchange

Dump the score for each variant and inspect it, having particular regard to the partitioning algorithms used. Report your findings.

And if you do, you deserve everything you get.

Where did you hear this? It is completely untrue . At both of the last two Information on Demand conferences this question was put to Keith Kohl, worldwide product manager for DataStage, who asserted that server jobs will continue to be supported indefinitely into the future. Given that job sequence...

The need to have admin privileges doesn't go away just because you're executing from the operating system. The same restriction would occur if you used UNLOCK as a non-admin user at the TCL prompt.

The point about a surrogate key is that it allows history to be preserved. What you have illustrated above is a Type 2 slowly changing dimension, when the actual key remains the same, a non-key column changes value, and you need to preserve the history. In a Type 1 slowly changing dimension you woul...

I usually advocate two staging areas, one between extraction and transformation, the other between transformation and loading. The reason is one of time windows: one usually has a limited time window for extraction of data, and only one opportunity to extract. Similarly one may have a limited time w...

I prefer to use list_readu from the operating system, because I can pipe its output through filters like grep to narrow my focus. I also like to capture the header line:

Be aware that invoking functions exposed via COM objects is noticeably slower than invoking other functions.

Also I'm not totally sure that you can call these external functions from parallel jobs - is it a C-callable interface?

Change your mindset. Rename the links. Each is just a link, each can accept further stages downstream.

If you know what the characters are, you can remove them with a Convert function - possibly specifying the character via a UniChar() function.

If you don't know what they are, then you need to create some kind of routine to preserve only the "ASCII" characters.

What exact version of DataStage are you running?
To find out what macros exist search for their definitions in DSINCLUDE/JOBCONTROL.H in the project directory.

Why do you have a space between the function name and the "(" character?

More likely to be scratch files from XML stages if they're in SOA folder.

Technically it means to use the ASCII NUL character (0x00) as the quote character. This is effectively using a zero-length string ("") as the quote character.