Multiple choice technology platforms and products

What type of expressions can be used in an Aggregator transformation variable port?

  1. Aggregate or Non-Aggregate expressions, provided they are not used together in a single variable port.

  2. Aggregate and Non-Aggregate expressions, together in the same variable port.

  3. Aggregate, Non-Aggregate and conditional expressions, together in the same variable port, provided that the variable port is also made a ‘group-by’ port.

  4. Non-Aggregate and conditional expressions only.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Aggregator transformation variable ports can only contain non-aggregate and conditional expressions. Aggregate expressions cannot be used in variable ports - they must be used in output ports only. Variable ports cannot mix aggregate with non-aggregate expressions.

Keep practicing — related questions