by

How to join three sources using joiner? Explain though mapping flow.

1 Answer

0 votes
by

We cannot join more than two sources using a single joiner. To join three sources, we need to have two joiner transformations.

Let’s say, we want to join three tables – Employees, Departments and Locations – using Joiner. We will need two joiners. Joiner-1 will join, Employees and Departments and Joiner-2 will join, the output from the Joiner-1 and Locations table.

Here are the steps.

  1. Bring three sources into the mapping designer.
    Sources-mapping-informatica-interview-questions
  2. Create the Joiner -1 to join Employees and Departments using Department_ID.
    Joiner-informatica-interview-questions
    Department-informatica- interview-questions
  3. Create the next joiner, Joiner-2. Take the Output from Joiner-1 and ports from Locations Table and bring them to Joiner-2. Join these two data sources using Location_ID.
    Joiner-2-informatica-interview-questions
  4. The last step is to send the required ports from the Joiner-2 to the target or via an expression transformation to the target table.
    Send-ports-informatica-interview-questions

Related questions

0 votes
    I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow....
asked Mar 28, 2021 by JackTerrance
0 votes
    I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow....
asked Mar 28, 2021 by JackTerrance
0 votes
    What is the difference between Mapping and Mapplet?...
asked Mar 26, 2021 by JackTerrance
0 votes
    How do you convert single row from source into three rows into target?...
asked Mar 28, 2021 by JackTerrance
0 votes
    Differentiate between Router and Filter Transformation?...
asked Mar 28, 2021 by JackTerrance
0 votes
    I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow....
asked Mar 28, 2021 in Technology by JackTerrance
0 votes
    How do you load only null records into target? Explain through mapping flow....
asked Mar 28, 2021 in Technology by JackTerrance
0 votes
    How do you load alternate records into different tables through mapping flow?...
asked Mar 28, 2021 in Technology by JackTerrance
0 votes
    Mapping of data-flow in an organization is very useful in understanding the risk better due to actual & potential data ... questions and answers pdf, mcq on Cyber Security pdf,...
asked Nov 2, 2021 in Education by JackTerrance
0 votes
    How can you increase the performance in joiner transformation?...
asked Mar 28, 2021 in Technology by JackTerrance
0 votes
    What is Joiner change in Informatica?...
asked Jun 7, 2021 in Technology by JackTerrance
0 votes
    Differentiate between joiner and Lookup Transformation....
asked Mar 27, 2021 in Technology by JackTerrance
0 votes
    What are the differences between Source Qualifier and Joiner Transformation?...
asked Mar 27, 2021 in Technology by JackTerrance
0 votes
    How to achieve Left Excluding JOIN using LINQ? In SQL: SELECT FROM Table_A A LEFT JOIN Table_B B ON ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Feb 27, 2022 in Education by JackTerrance
...