DSXchange

Murali,

you may probably use the MERGE stage to do this. This is the only way to merge 2 files for input and continue with one output stream.

Another possible option would be to read one of the files with a surrrogate key into a hash file then read it in atransformer as a regular lookup.

Klaus

Iawan, this is a rather "standard" technique with DataStage job control. Please find below a very simple sample that may show you the technique on how to retrieve parameters from a file and pass them over to a job that is to be started. For further information please have a look into the &...