DSXchange

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

Thanks

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.

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.