Capturing non key column on lookup match.
Posted: Fri Feb 15, 2008 10:25 am
Hi,
I have a requirement that I state as follows:
There are two cols in source table : ID1 and DATA
There is a reference table having the following cols : ID1 and ID2.
I have to translate ID1 to ID2 in the source file, IF a coresponding match exists in the reference table between ID1 and ID2. If there is no match then populate ID1 as it is.
Currently I am using a lookup stage, where I connect ID1 col from source link to ID1 in the reference link, and then pull ID2 to the target side column.
Is this correct approach? because I am not getting desired results. All the rows from the source files get populated unto the target. What could be a better soulution?
Thanks!
I have a requirement that I state as follows:
There are two cols in source table : ID1 and DATA
There is a reference table having the following cols : ID1 and ID2.
I have to translate ID1 to ID2 in the source file, IF a coresponding match exists in the reference table between ID1 and ID2. If there is no match then populate ID1 as it is.
Currently I am using a lookup stage, where I connect ID1 col from source link to ID1 in the reference link, and then pull ID2 to the target side column.
Is this correct approach? because I am not getting desired results. All the rows from the source files get populated unto the target. What could be a better soulution?
Thanks!