Multiple choice technology

In an Aggregator transformation, the aggregation expression can contain_______

  1. Aggregate functions

  2. Conditional clauses

  3. Nested aggregate functions

  4. Non-aggregate functions
Reveal answer Fill a bubble to check yourself
A,B,C,D Correct answer
Explanation

The Aggregator transformation in Informatica allows aggregation expressions to contain aggregate functions (SUM, COUNT, etc.), conditional clauses (CASE/DECODE), nested aggregate functions (AVG(SUM(x))), and even non-aggregate functions for conditional logic. This flexibility enables complex aggregation logic within a single transformation, supporting sophisticated data summarization requirements.

Keep practicing — related questions