Multiple choice technology platforms and products

Which of the following is not a type of join in a joiner transformation

  1. Normal

  2. Master outer

  3. Detail outer

  4. Full outer

  5. Full Inner
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

Informatica Joiner supports four join types: Normal (inner join), Master Outer (preserves master rows), Detail Outer (preserves detail rows), and Full Outer (preserves all rows from both sides). 'Full Inner' is not a standard join type in Joiner transformation or in SQL - the term is contradictory as a join cannot be both 'full' (which implies all rows from both sides) and 'inner' (which implies only matching rows). The valid types are Normal Join, Master Outer Join, Detail Outer Join, and Full Outer Join.

Keep practicing — related questions