Hi,
i have two fileds in source f1,f2 and in reerence data i have r1,r2 column.
first i should lookup f1 and r1 then for matchinf records i should pass r2 .for unmatching records i should lookup f2 with r1 then i should pass r2 for those records.is this one how can i do with singale lookup stage.
.........
join two keys with lookup stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 132
- Joined: Tue Sep 04, 2007 11:38 am
- Location: NOIDA
-
- Participant
- Posts: 47
- Joined: Tue Feb 23, 2010 12:16 am
- Location: CHENNAI
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 47
- Joined: Tue Feb 23, 2010 12:16 am
- Location: CHENNAI
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can give a condition about whether or not to attempt the lookup, but you can not make the lookup itself conditional which is what your original post suggests. Perform the lookup with a Lookup stage unconditionally, and handle the condition elsewhere - maybe only load the records into the reference data set that meet the condition, maybe test the condition downstream of the Lookup stage in a Filter, Switch or Transformer stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.