🎴 Flashcard Mode
Mixed IT Concepts Quiz
Card1 / 20
Mastered0
Review0
QuestionClick to flip
How can we improve session performance in aggregator transformation?
AnswerClick to flip back
A
By using Incremental Aggregation
B
Sorted input
C
Create the sorter transformation before the aggregator
💡 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.