Multiple choice technology packaged enterprise solutions

Which transformation is used to perform aggregation function

  1. Expression

  2. Filter

  3. XY Inputs

  4. Aggregator
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The Aggregator transformation in OWB is designed to perform aggregate functions (SUM, COUNT, AVG, MIN, MAX, etc.) on groups of data, similar to SQL GROUP BY operations with aggregate functions. It processes multiple input rows and produces summarized output rows based on grouping specifications. The Expression transformation evaluates row-level expressions, Filter filters rows based on conditions, and XY Inputs is not a standard transformation name.

AI explanation

The Aggregator transformation is the Informatica component designed to perform group-based calculations like SUM, COUNT, AVG, MIN, and MAX across rows. Expression performs row-level calculations without grouping, and Filter only removes rows based on a condition — neither is built to aggregate values across groups of rows.

Keep practicing — related questions