DSXchange

You won't ever see them there. They are automatic, and not to be edited. You will see them at the other end of the reject link (in your specific case, in the Peek stage).

11 match passes is a lot of work. About the only thing I could suggest would be throwing more nodes at it. Hopefully key field A has plenty of distinct values to make that a feasible suggestion.

Specify your record delimiter string property in the Sequential File stage as "DOS style".

The parallel Sequential File stage is notoriously bad at handling quoted strings containing field delimiters.

Create a server Shared Container containing a server Sequential File stage and use this Shared Container in your parallel job.

Add an extra exit condition from the loop, such as WHILE a > 0.

The message suggests that, somehow, DataStage is still seeing Decimal(8,0) as the data type. Time for some detective work.

Good. I suspect the VPHONE and know that VTAXID don't work where I am.

You can't fit a size 9 foot into a size 8 shoe. This is similar.

Does anyone have an example of an LDM configuration file that the istool glossary ldm2bg command can use? The documentation suggests that you can use -cfg-sample option to generate a sample, but using this in a command throws a weird error: it informs one that this is not an option and then produces...

Beware that the validation rule sets (VEMAIL, VPHONE, etc.) are highly US-centric.

For example VEMAIL can not cope with zaphod@h2g2.co.uk (the rule set requires a "com" domain, not a "co" domain).

I wonder if the interpolated WHERE clause has anything to do with the range partitioning algorithm used in Oracle?

Think about the possibility of updating shrunken (summarised) fact tables.

The extension is not required. Put another way, no extension is required for the state file name.

Within the ODBC Connector stage click on the reject link in the picture frame. Some options will be presented.

Remove the quotes from around DSJ.LOGSTARTED. This is a predefined integer constant. By making it a string constant you will never succeed in matching the value. Therefore you have an infinite loop.