DSXchange

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

No.

Hi,

plz can you specify what type of join are supported by lookup and merge stages.

cheers;
Saama

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.