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.
How do we achieve right and Full outer joins in Lookup
Moderators: chulett, rschirm, roy
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 ?
Mohmmed Elgendy
Senior System Analyst
Data IntegrationTeam
Etisalat Egypt
+20 1118511161
Senior System Analyst
Data IntegrationTeam
Etisalat Egypt
+20 1118511161
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom