DSXchange

Could you please explain the difference between Join Stage and Merge Stage..

I could understand that both the stages work based on the Key Column and they take multiple input links. But what is the exact difference between each of them.

I have searched in the forum and found a similar post but it does not provide much information.

Merge Stage has one master and multiple update links and that many number of reject links possible.
Join Stage can have multiple input links and only one output link and it can not have reject links.For Full outer join it can have only two input links.

You can perform Inner,Left,right and full outer join using Join Stage but using merge stage only Inner and Left Outer(Consider left as master link) join is possible.

In Merge Stage key field of master link should have unique records.

Did you check the documention? From what I recall the differences between those two stages are a specific area of discussion there...