Multiple choice technology

How can we improve session performance in aggregator transformation?

  1. By using Incremental Aggregation

  2. Create the sorter transformation after the aggregator

  3. Sorted input

  4. Create the sorter transformation before the aggregator
Reveal answer Fill a bubble to check yourself
A,C,D Correct answer
Explanation

Aggregator performance can be improved through three methods: Incremental Aggregation caches previous results and only processes new data, Sorted Input reduces sorting overhead when data is pre-grouped, and placing a Sorter before the Aggregator ensures data arrives grouped. Placing a Sorter after the Aggregator serves no purpose since aggregation is already complete. The key is pre-sorting before aggregation occurs.

Keep practicing — related questions