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

Interview Candidate
Oct 8th, 2015
9
5157

Informatica

Answer

Showing Answers 1 - 9 of 9 Answers

basireddy

Oct 27th, 2015

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

kiran

Nov 13th, 2015

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

Kiran

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.