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

In an Informatica Aggregator transformation, variable ports can only contain non-aggregate and conditional expressions. They cannot contain aggregate functions (such as SUM or AVG) because variable ports are evaluated row-by-row.

Keep practicing — related questions