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

Open 1 Answers 27 Views

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

1 Answer

0

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
by (279k points)
...