Regarding Merge and Join Stage

[dstest]

Is there any performance difference between join and merge stage except merge has a reject link and join does not have.

Thanks

[csri]

If your data is small then merge is more efficient but if you have huge lookup data then join is prefered to go I think.

[ray.wurlod]

Without knowing how you define performance it is impossible to answer your question. The stage types do different things - a Join stage performs a join, a Merge stage effects a Master-and-Update mechanism.