Multiple choice technology

Which transformation should be used before aggregator to improve performance ?

  1. Expression

  2. Sorter

  3. Normalizer

  4. Filter

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

Using a Sorter stage before an Aggregator groups identical keys together, significantly improving aggregation performance. When data is sorted by the key columns, the Aggregator can operate in sorted mode which is much more efficient than unsorted mode.