LakshmiKrishna

• Nov 5th, 2007

 

Hi There is no major difference between three stages in terms of Functionality. They

mainly in the memory they use, the treatment of

rows with unmatched keys, and their requirements for data being input. Look Up, Join stages have only one Reject link, but Merge state can have two or more reject links for each reference link.

Thanks
LakshmiKrishna

Pavan Batchu

• Nov 12th, 2007

 

Lookup stage:
1.Can only return multiple matching rows from one reference.
2. Can reject rows based on constraint.
3. Can set failure.
4. Does not need partitioned and sorted input.

Merge stage:
1. Can reject rows if fail to find match.
2. Does need partitioned and sorted input.

Join stage.
1. No reject.
2. Does need partitioned and sorted input.

madhavsandireddi

 Profile Answers by madhavsandireddi 

• Feb 24th, 2011

 

The major difference between LKP stage, Join stage, merge stage are

LKP & JOIN: If the reference data in the LKP stage is huge when compared to the
primary data. there is no reject requirement then blindly use JOIN stage....

In LKP stage, only inner join and left & right outer join is possible...

MERGE: If we have reject requirement then we use merge stage join & merge
stage are possible left & right & full outer join..

Thank you
Madhav