Learning Informatica PowerCenter 10.x(Second Edition)
上QQ阅读APP看书,第一时间看更新

Using Group By

Using the Group By option in aggregator transformation, you can get the result of the aggregate function based on the group. Suppose you wish to get the sum of salaries of all employees based on Department_ID. We use the group by option to implement the scenario as shown in the following screenshot: