Multiple choice technology

Will union transformation allow duplicates?

  1. True

  2. False

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Yes, the Union transformation in Informatica allows duplicates. Unlike SQL's UNION which removes duplicate rows by default (use UNION ALL to keep them), Informatica's Union simply concatenates all rows from multiple inputs without any duplicate elimination.