Hi Gurus,
Does lookup and merge support all types of joins. what i mean to say is that can we do inner, left, right and full outer join with merge and lookup stages.
cheers,
Saama
Regarding merge and lookup stages
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Lookup
Left outer join if failed lookup rule is Continue
Inner join if failed lookup rule is Drop or Reject
Merge
Left outer join if mismatched master rule is set to Keep
Inner join if mismatched master rule is not set to Keep
However, this is only true if the master input is de-duplicated, since update input rows are consumed.
Left outer join if failed lookup rule is Continue
Inner join if failed lookup rule is Drop or Reject
Merge
Left outer join if mismatched master rule is set to Keep
Inner join if mismatched master rule is not set to Keep
However, this is only true if the master input is de-duplicated, since update input rows are consumed.
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.