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
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.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
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.