Aggregator Stage is a processing stage that can have one input and one output link. Classifieds records from the input link into groups and computers the totals or performs specified aggregator functions for each group. Aggregated information is sent to the output link. The stage editor allows you to specify one or more grouping keys in addition, providing the way specify the aggregation function and the column on which it is to be operated. Records can be grouped on one or more keys.
A group is a set of records with the same value for grouping keys. After grouping the records on keys aggregator stage performs specified functions on grouped records.
If you want to learn more about all stages in datastage . Go to datastage blog to learn online free.