Is right outer join possible in lookup stage

fredy · Post by **fredy** » Mon Sep 01, 2008 8:50 am

Hi,

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

Thanks in advance..

hamzaqk · Post by **hamzaqk** » Mon Sep 01, 2008 9:21 am

by setting up failure property in lookup stage to true ?

fredy · Post by **fredy** » Mon Sep 01, 2008 10:31 am

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.

ray.wurlod · Post by **ray.wurlod** » Mon Sep 01, 2008 2:54 pm

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.