DSXchange

Hi,

Could you tell me how can we implement right outer join in lookup stage?

Thanks in advance..

by setting up failure property in lookup stage to true ?

Thank you very much for your reply.

If i give lookup failure property to continue then that will be a left outer join.

I have a number of reference tables (number of records few) and i want to join it with a source table. I need to right outer join with the reference tables.

Right outer join is not possible with a Lookup join. If you reverse the sense of the stream and reference inputs and do a left outer join (rule is "Continue") then you have a functional equivalent. However, this is not feasible if you have multiple reference inputs. You need to use a Join stage in this case.