OWB Aggregator Issues

Issues while using Aggregators:

The aggregator operator performs SUM or AVG operations on the ingroup attributes and provides the aggregated result set at the outgroup. Aggregators are useful tools but can take a lot of our design time if we have to group a large number of columns based on a few key values. The reason behind this is that in an aggregator the ingroup values does not come in the outgroup by default. We have to manually type in the outgroup attribute names and data types. Consider a mapping which requires you to group 100 columns based on one key value. All the 100 columns need to be manually typed in.

Solution:

An useful work around is to bring all the ingroup attributes in the group by clause. By default OWB adds the group by attributes in the outgroup. Now the only job left is to change the aggregation operation to be performed on each attribute.