Multiple choice technology

Which of the following is not true for joiner?

  1. If selected, case-sensitive string comparisons are done in joiner

  2. A normal or master outer join performs faster than a full outer or detail outer join

  3. A master outer join ONLY keeps all rows of data from the detail source

  4. Sorted input can be used for joiner
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

A master outer join in Joiner transformation keeps all rows from the MASTER source, not the detail source. This is the opposite of what option C states, making it the false statement that the question asks for. The other options are true: case-sensitive option exists for string comparisons, master outer join is generally faster than full/detail outer, and sorted input can improve joiner performance.

Keep practicing — related questions