Look Up failure due to duplicates

Das · Post by **Das** » Mon Mar 26, 2007 7:25 am

Hi,
Please Suggest me a solution for the below issue.

I want to perform a look up operation ,for that i have one column TAB1.A of [Non Key] from the source and i wanated to look up to TAB2.A [key column in that table] and populate some values from TAB1 and TAB2 to Target.
When i was running the job i am geeting the error as like "PQR..Transformer_1: Reference lookup generated %d rows. Only the last row was used" and job is getting failded.How do i perform this operation

DSguru2B · Post by **DSguru2B** » Mon Mar 26, 2007 7:36 am

Are you using ODBC stage for lookup. Because only that stage supports multiple row returns. Search on keywords "Reference lookup generated %d rows. Only the last row was used" to get more posts relating to your error.

Das · Post by **Das** » Mon Mar 26, 2007 7:48 am

DSguru2B wrote:Are you using ODBC stage for lookup. Because only that stage supports multiple row returns. Search on keywords "Reference lookup generated %d rows. Only the last row was used" to get more posts relating to your error.

Thanks,I am using INformixCLI stage

DSguru2B · Post by **DSguru2B** » Mon Mar 26, 2007 7:49 am

Then I guess you need to change to either odbc stage or return single row per key.

chulett · Post by **chulett** » Mon Mar 26, 2007 7:55 am

As noted, change your query to not return duplicates but rather the preferred singleton row.