Multiple choice technology

Which of the following is true?

  1. Joiner transformation cannot be used if either of the input pipelines contains an update strategy transformation.

  2. Joiner transformation cannot be used if a sequence generator is used directly before it.

  3. Both.

  4. None of these.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Joiner transformation has specific restrictions: (1) It cannot be used if either input pipeline contains an Update Strategy transformation because Joiner needs stable input and Update Strategy flags rows for database operations which conflicts. (2) A Sequence Generator connected directly before Joiner causes issues because Sequence Generator is active and generates rows, potentially disrupting the sorted input requirement for Joiner. Both statements are true.

Keep practicing — related questions