DSXchange

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

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.