top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Unique Joiner Transformation in Informatica?

+2 votes
399 views

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

posted Mar 2, 2016 by Sunil

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

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.

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

answer Mar 3, 2016 by Manikandan J
Similar Questions
+1 vote
How to transfer data to the target table from multiple sources without using Joiner Transformation in informatica?

I have two sources (source A and Source B), source B is an another one target table in my db. both are in diff user id . Now i have to transfer some data,s from these two sources to target table. Can i transfer data without using the joiner transfermation? how to do ?

+1 vote
Transformations that cannot be placed between the sort origin and the Joiner transformation

What are the transformations that cannot be placed between the sort origin and the Joiner transformation so that we do not lose the input sort order.

+2 votes
Difference between Joiner and Union Transformation

What is the difference between Joiner and Union Transformation? Also, Should we use Router instead of Joiner, to increase performance when there are multiple sources?

...