Page 1 of 1
join two keys with lookup stage
Posted: Mon Oct 17, 2011 10:54 pm
by vinsashi
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.
.........
Posted: Mon Oct 17, 2011 11:29 pm
by ray.wurlod
Don't do it. Use two Lookup stages. It's cleaner.
Posted: Tue Oct 18, 2011 1:03 am
by vinsashi
will it possible.if itpossible how to do what are the options i should mention
Posted: Tue Oct 18, 2011 3:38 am
by meet_deb85
I don't think there is any way of doing it using 1 lookup stage
Posted: Tue Oct 18, 2011 4:43 am
by manoj_23sakthi
i am not sure abt this...
in constrain we can do this...
Posted: Tue Oct 18, 2011 3:47 pm
by ray.wurlod
Lookup stages don't have constraints.
Posted: Wed Oct 19, 2011 1:59 am
by manoj_23sakthi
hi ray,
In look up property we can give condition
Posted: Wed Oct 19, 2011 4:08 pm
by ray.wurlod
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.