Multiple choice technology

Which of the following is true about union transformation?

  1. The Union transformation generates transactions

  2. The Union transformation removes duplicate rows

  3. When the transformation receives data from multiple transaction generators, the Integration Service drops all incoming transaction boundaries

  4. You can use a Sequence Generator upstream from a Union transformation
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The Union transformation in Informatica is a passive transformation that combines data from multiple sources. When it receives data from multiple transaction generators, the Integration Service drops all incoming transaction boundaries and creates new transaction boundaries. Option A is incorrect because Union does not generate transactions. Option B is incorrect because Union does not remove duplicates (Unioner does). Option D is incorrect because you cannot use an active transformation like Sequence Generator upstream from Union.

Keep practicing — related questions