DSXchange

Hi,

Can you please provide me info how to implement OR condition in lookups.

Ex:

Select * from table1
where table1.col1 in (select col1 from table2) or
table1.col1 in (select col1 from table3);

Regards,
harsha

You can use sparse lookups for this kind of stuff. But, again it would not be good on performance if your input data is huge...

Gotta wait for the gurus

Build your lookup dataset or if you are using the join stage, in your reference join, use a UNION of col1 from table2 and table3. This way you will have all your values that need to be looked up upon from your input data.

What stages are you using to accomplish your task. We can guide you If you give us info on it.

Thanks.