Multiple choice technology databases

Sorted input is used for which transformation?

  1. Normalizer

  2. Sequence Generator

  3. Sorter

  4. Aggregator
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Aggregator transformation specifically benefits from sorted input. When you enable 'Sorted Input' option in Aggregator, it assumes data is already grouped by the specified keys. This improves performance because the aggregator can optimize memory usage and processing - it doesn't need to cache all rows before grouping. Normalizer pivots columns to rows (no sorting benefit), Sequence Generator creates sequential IDs (no sorting needed), and Sorter produces sorted output (it doesn't consume it).

Keep practicing — related questions