Hi,
Could you tell me how can we implement right outer join in lookup stage?
Thanks in advance..
Is right outer join possible in lookup stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.