How do we achieve right and Full outer joins in Lookup

vputta · Post by **vputta** » Tue Nov 03, 2009 6:05 am

How do we achieve right and Full outer joins in Lookup.I could not do it with setting lookup conditions for stream and reference links .

Lookup failure condition - Stream Reference

Normal Join - Drop Drop
Left outer - Continue Continue
Right Outer - ? ?
Full outer - ? ?

Thanks.

gssr · Post by **gssr** » Tue Nov 03, 2009 6:15 am

By Changing the link Order ,You can achieve the Right outer !!

vputta · Post by **vputta** » Tue Nov 03, 2009 6:22 am

You mean stream should be made Reference and vice versa ?

mgendy · Post by **mgendy** » Tue Nov 03, 2009 6:28 am

you could acheive right outer join by setting lookup failure to continue , and swap refrence link and stream link to obtain the correct side 'left or right ' , but i think you couldn't implement full outer join using one lookup , why didn't you use join stage instead ?

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Nov 03, 2009 7:04 am

Why do you want to restrict with lookup stage for join actions?

You cannot do right or full outer join using lookup stage alone.

Better use join stage.