Types of join used in joiner transformation
-
Normal
-
Master outer
-
Detail outer
-
Full outer
-
All the above
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.