Terdata to DB2 lookup
Posted: Wed Aug 31, 2005 7:14 pm
Hi ,
I have a job, where Data from Teradata goes to Hashfile and then to transformer. And doing a lookup with DB2 , in Transformer, where file data goes to flatfile.
TD-----HS
DB2----- Trans------Flatfile
When i run the job, i am getting some 10000's of warinings like below:
Transformer_50: Reference lookup generated 2 rows. Only the last row was used.
Please help me how to get rid of these warnings.
Thanks in advance.
I have a job, where Data from Teradata goes to Hashfile and then to transformer. And doing a lookup with DB2 , in Transformer, where file data goes to flatfile.
TD-----HS
DB2----- Trans------Flatfile
When i run the job, i am getting some 10000's of warinings like below:
Transformer_50: Reference lookup generated 2 rows. Only the last row was used.
Please help me how to get rid of these warnings.
Thanks in advance.