Multiple choice technology databases

Which is true regarding joiner transformation?

  1. We cannot use joiner transformation when any input pipeline contains update strategy transformation

  2. We can connect sequence generator transformation directly before the joiner

  3. Both of above options

  4. None of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Joiner transformation cannot be used when any input pipeline contains an Update Strategy transformation. This is because Update Strategy marks rows for insert/update/delete, which creates row-level operations that conflict with Joiner's set-based joining logic.

Keep practicing — related questions