Multiple choice technology

What is the purpose of the mapping variable property "aggregation type"?

  1. It is used to determine the final value of the variable across sessions with multiple partitions

  2. It is used to determine how the Aggregator transformation will calculate values of the variable across rows.

  3. It is used to determine how the Aggregator and Rank transformations will calculate values of the variable across rows.

  4. It is passed to the source database server to determine how aggregations of variable fields are handled
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The aggregation type property for mapping variables specifies how to compute the variable's final value when sessions run with multiple partitions. Common aggregation types include MAX, MIN, AVG, COUNT, which determine whether the variable holds the highest, lowest, average, or total value across all partitions.

Keep practicing — related questions