Unique Joiner Transformation

If both source have same rows, same number of columns and no duplicate which one should be choosen to be master in joiner trasnformation

Showing Answers 1 - 3 of 3 Answers


  • Oct 27th, 2015

I believe , which one we drop first in joiner that can be master.

  Was this answer useful?  Yes


  • Nov 13th, 2015

Integration service can calculate the least number of records that should be in a master

  Was this answer useful?  Yes


  • Feb 2nd, 2016

When we drag first source into a joiner, Integration services treat them as detail, later source when dragged into the joiner, it is treated as master,

There is one more check may b we can consider, correct me if I am wrong, We can have master table as source which contains less number of constrains defined, when compared to other source table.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions