Multiple choice technology

In a joiner transformation the following helps in performance

  1. Sorted input option

  2. Using the table with more rows as master

  3. Both a and b

  4. Either a or b
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The 'Sorted input' option in a Joiner transformation significantly improves performance because it allows Informatica to use a more efficient merge join operation instead of a nested loop join. The smaller table should be used as master, so option B is incorrect.

Keep practicing — related questions