Multiple choice technology

The Union transformation does not remove duplicate rows and is similar to ________SQL statement

  1. UNION

  2. UNION ALL

  3. INTERSECT

  4. NONE
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The Union transformation in Informatica combines data from multiple sources without removing duplicate rows, which is identical to the UNION ALL SQL statement. Unlike SQL's UNION (which removes duplicates) or INTERSECT, the Union transformation preserves all rows including duplicates, making it equivalent to UNION ALL in behavior.

Keep practicing — related questions