Multiple choice technology

Performance of an Aggregator Transformation can be improved by

  1. Passing the input data in groups

  2. Sort the Input data according to the Group By ports

  3. Pass Unsorted data as Input

  4. Use Nested Aggregate Functions
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Sorting input data according to Group By ports significantly improves Aggregator performance. When data is pre-sorted, the aggregator doesn't need to build and manage a large aggregate cache in memory; it can process groups sequentially. Passing unsorted data requires caching all rows until all groups are complete, increasing memory usage and processing time.

Keep practicing — related questions