Hi ,
Can anyone please let me what all joins possible in lookup stage and Merge stage
As we have inner,left, right and outer joins in JOIN stage , i wanted to know what all joins can be done in merge and lookup stage
what are different types of joins possible in lookup stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Lookup stage does lookups, not joins. You can emulate both inner and left outer join, depending on the Lookup Failed rule.
Merge stage definitely does not do a join; it follows a master and update(s) model. Again, you can emulate joins, this time via the Unmatched Master property.
Merge stage definitely does not do a join; it follows a master and update(s) model. Again, you can emulate joins, this time via the Unmatched Master property.
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.