Lookup

[yarlly]

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

[ray.wurlod]

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.