Multiple choice technology

Identify which of the following is active transformations

  1. a. Lookup

  2. b. Sequence generator

  3. c. Aggregator

  4. d. Sorter

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

The Aggregator transformation is active because it performs calculations like GROUP BY, SUM, AVG which can reduce multiple input rows to fewer output rows. Active transformations change the number of rows passing through. Lookup, Sequence Generator, and Sorter are passive transformations - they process one row in and produce one row out without changing the row count.