Multiple choice technology databases

When we group the data through aggregator it outputs which row of each group as default?

  1. First

  2. Last

  3. Any

  4. None
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The Aggregator transformation outputs the last row of each group by default because it processes rows sequentially and keeps updating the aggregate values until the final row is processed. The first and intermediate rows are used for calculations but only the final row of each group is retained and passed through to the output.

Keep practicing — related questions