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
Transformer stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 94
- Joined: Wed May 08, 2002 8:44 am
- Location: Germany
- Contact: