Identify which of the following is active transformations
-
a. Lookup
-
b. Sequence generator
-
c. Aggregator
-
d. Sorter
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.