How to impliment left outer jion with Lookup

stiwari · Post by **stiwari** » Wed Aug 30, 2006 1:33 am

Hi All,

While loading Target table I have used left outer join/right outer join with join stage but performance wise it's very slow now I want to use Lookup stage instead of join stage but there is no option to take any Outer join.....If any one have any idea...Plz share it with me......

Thanks in advance

stiwari

Kirtikumar · Post by **Kirtikumar** » Wed Aug 30, 2006 1:42 am

Lets consider two tables EMPL and DEPT.

If you want to do join on these table and EMPL is your left table, then - make EMPL as your stream link for lookup stage and DEPT as your reference link. DeptNo will be lookup key.

Then in the contraint box, set the Lookup failure to Continue meaning even if the EMPL record is not there in DEPT, send it on the output.

I think full outer can not be done using lookup.

stiwari · Post by **stiwari** » Wed Aug 30, 2006 2:20 am

Kirti,

Thanks for your quick reply, I have tried this logic it's working fine... :D

Regards
stiwari

kumar_s · Post by **kumar_s** » Wed Aug 30, 2006 6:13 am

Lookup will be good and effecient enough as long as the lookup data was able to find into memory.