Multiple choice technology databases

When we can use sorted input in aggregator?

  1. When nested aggregate function are used in the aggregator expression

  2. Incremental aggregation is used in session

  3. In case of data driven source data

  4. None of above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Sorted input cannot be used in Aggregator transformations when nested aggregate functions are present in the expressions or when incremental aggregation is enabled in the session settings. Since the other options describe situations where sorted input is invalid, "None of above" is the correct choice.

Keep practicing — related questions