Having a OR condition in Lookup

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
kogads
Premium Member
Premium Member
Posts: 74
Joined: Fri Jun 05, 2009 5:36 pm

Having a OR condition in Lookup

Post by kogads »

Hello all,

Can someone please let me know if they have implemented a OR condition in Lookup.

One Primary link----with 3 columns

first secondary link----with 1 column
second secondary link----with 1 column
third secondary link----with 1 column

The first column in Primary link looked up with column in first secondary link
The second column in Primary link looked up with column in second secondary link
The third column in Primary link looked up with column in third secondary link

Now, I need an OR condition between these. if we just do a lookup we have AND condition.

Thanks in Advace
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Not in the Lookup stage, but you can in a downstream Transformer stage. Remember the philosophy "one task, one stage type". Lookup stages do lookups. That's all.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kogads
Premium Member
Premium Member
Posts: 74
Joined: Fri Jun 05, 2009 5:36 pm

Post by kogads »

Thanks Ray...
Post Reply