Multiple choice technology platforms and products

How many minimum no of joiner transformations are needed to join 4 different heterogenous sources?

  1. 1

  2. 2

  3. 3

  4. 4
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

To join 4 heterogeneous sources in Informatica/ETL, you need 3 Joiner transformations arranged in a pipeline. Joiner 1 merges Source A and Source B. Joiner 2 merges that result with Source C. Joiner 3 merges that result with Source D. Each Joiner can only combine two data streams, so for N sources you need N-1 Joiners.

Keep practicing — related questions