Multiple choice technology

which of the following is true about Union transformation

  1. a.All input groups and the output group must have matching ports. The precision, datatype, and scale must not be identical across all groups.

  2. b. The Union transformation does not remove duplicate rows.

  3. from a Union transformation.

  4. d. You can create multiple input groups and output groups.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The Union transformation merges multiple input groups into a single output group but does NOT remove duplicate rows - all rows from all sources pass through to the output. This distinguishes it from other transformations that might perform deduplication. While ports must match across input and output groups by name and datatype, the precision, datatype, and scale can vary as long as they are compatible. The Union transformation is passive, not active, as it doesn't change the number of rows.

Keep practicing — related questions