Multiple choice technology

If 4 tables needs to be joined how many joiner transformation are required

  1. 1

  2. 2

  3. 3

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

To join 4 tables using Joiner transformations in Informatica, you need 3 Joiner transformations. Joiner transformations only accept two input sources (master and detail). The process is hierarchical: join Tables A and B (Joiner 1), join that result with Table C (Joiner 2), then join that result with Table D (Joiner 3). Each joiner reduces the number of data streams by one, so for n tables, you need n-1 joiners.

Keep practicing — related questions