Regarding merge and lookup stages

Saama · Post by **Saama** » Wed May 23, 2007 7:17 pm

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

ray.wurlod · Post by **ray.wurlod** » Wed May 23, 2007 9:44 pm

Saama · Post by **Saama** » Wed May 23, 2007 10:07 pm

Hi,

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

cheers;
Saama

ray.wurlod · Post by **ray.wurlod** » Thu May 24, 2007 1:34 am

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.