2)To get the cumulative summary output component used is
-
a. Rollup
-
b. Scan
-
c. Normalize
-
d. Replicate
B
Correct answer
Explanation
The Scan component generates cumulative summary output (running totals, counts, etc.) by processing records sequentially and carrying forward aggregation values. Unlike Rollup which produces group-based summaries (one per group), Scan produces output for every input record with cumulative values. Normalize and Replicate serve different purposes - data standardization and duplication respectively.