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: