DSXchange

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.

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

You mean stream should be made Reference and vice versa ?

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 ?

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.