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.
Join Stage Vs Merge Stage in DS- Parallel JOB
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 14
- Joined: Wed May 01, 2013 1:06 pm
Join Stage Vs Merge Stage in DS- Parallel JOB
Thanks & Regards,
Gokula Krishnan
Gokula Krishnan
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
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.
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.
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/