Hi All,
I am doing lookup on 2 tables, the source table has duplicate records and giving out the output to 2 diffrent Sequential files.Is there any function that I can use in tranformer so that unique records are loaded into one of the sequential file.
Any help Please.
Thanks
yar
Lookup
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Not a function, but some stage variables. Make sure that the input data are sorted by the keys on which your "duplicate" decision is based, and detect whether each row is the same as or different from the previous one using the stage variables.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.