Multiple choice technology

Types of join used in joiner transformation

  1. Normal

  2. Master outer

  3. Detail outer

  4. Full outer

  5. All the above

Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

The Joiner transformation in Informatica supports four types of joins: Normal join (inner join), Master Outer join (preserves all master rows), Detail Outer join (preserves all detail rows), and Full Outer join (preserves all rows from both sources). These options provide flexibility for different data integration scenarios.