Aggregate Transformation Wizard Welcome Page

The Aggregation Transformation wizard allows you to calculate and store aggregated values of an attribute, such as sum, average, standard deviation, and other functions that can be calculated in a SQL query. These values might be interesting in their own right, or might add new information to an existing record in a table or view.

For example, sales data might be collected on a daily basis and then be aggregated to the week level; the week data could be aggregated to the month level; and so on.

The Aggregate Transformation wizard allows you to add multiple aggregations to a new view. For each aggregation, you can select an attribute to aggregate, an aggregation function, and an ALL or DISTINCT option. You can also specify GROUP BY and HAVING clauses.

The output of the wizard is described in Output.

If you do not want to see this page the next time that you launch the wizard, check the Skip this Page Next Time box.

Click Next to continue.