what are different types of joins possible in lookup stage

monaz · Post by **monaz** » Tue Oct 27, 2009 1:07 am

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

ray.wurlod · Post by **ray.wurlod** » Tue Oct 27, 2009 9:21 am

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.