DSXchange

Did anyone ever get around to producing that list of undocumented features in DataStage?

Note also that analysts such as Gartner also charge a lot of money for their reports.

Do your metadata correctly specify 64 as the length of the GUID columns in both the tables?

If so then you've probably uncovered a bug, and you should contact your official support provider. You might also search Fix Central to see whether there's any patch available for a bug of this kind.

Why do you say "the source and target connections are working fine"? How did you verify this in IA?

The server job Pivot stage can only do horizonal pivot. To perform vertical pivot in a server job use Sort, Transformer and Aggregator stages. Use stage variables to construct the output lines, and an Aggregator stage to preserve only the Last of each group.

Try partitioning on the first sort key column (MSG_ID) only, and sorting on both columns (MSG_ID, TRAN_ID).

Which stage is throwing the "input not sorted" error?

And you only have 4GB memory. Could be something in that. You might also research techniques for having the JVM allocate a non-default amount of memory.

May we ask why? As with any complex software that's been around for over a decade, there are thousands of known issues. Each time a new version is released, there is a document outlining them, the ones that have been fixed and the ones that have not been fixed. Perhaps you could research those. Just...

Sort by NAME and TYPE, generate a key change column, and use stage variables in Transformer stage to compare with previous rows. Generate your output only for differences.

More detail is clearly required, if only for the Lost Boys. You can have one job start another, even it is part of a web service (there is, of course, a small response time penalty). For example this might be a sequence job, or a server job with a call to the SDK routine UtilityRunJob. Either way it...

One way to do it would be to write the value appropriately into a "values file" for the Parameter Set that the second job uses. Parameter Set values files are stored in the project directory, in a sub-directory called ParameterSets. Within this sub-directory is an eponymous sub-sub-directo...

You could specify a "sparse lookup" in the Teradata Connector stage.

%s is a placeholder for printf() and other functions. It seems like your instance cannot find the actual error message it needs to display. Was it genuinely successfully installed? (Check the install log.)

Windows XP is not supported for anything but the client tier.

Duplicates in the stream input link.
Duplicates in the reference input link.
Both of the above.

Why are you using sparse lookup for such a small volume?