Aggregator transformation

Aggregator transformation is used for calculations using aggregate functions on a column as against in expression transformation, which is used for row-wise manipulation.

You can use aggregate functions such as SUM, AVG, MAX, MIN in aggregator transformation.

Scenario for aggregator transformation: Use the EMPLOYEE oracle table as the source, and get the sum of salaries of all the employees in the target.

Perform the following steps to achieve the functionality:

1. Import the source using the Employee Oracle table in the Source Analyzer, and create Target TGT_TOTAL_SALARY in Target Designer.
2. Create mapping m_AGG_TOTAL_SALARY, and drag the source and target from the Navigator to Workspace. Create the aggregator transformation with the name AGG_TOTAL_SAL.
3. As we need to calculate TOTAL_SALARY, drag only the SALARY column from the Source Qualifier to aggregator transformation, as shown here:
   
4. Add a new column TOTAL_SALARY in the aggregator transformation to calculate the total...