Transformer stage

[Klaus Schaefer]

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