Working with Aggregation Tables

Set up the Aggregation Transformation in the Process Flow Diagram

To create an aggregation table with an aggregation wizard, you must first perform the following preliminary steps:

Open a job on the Diagram tab of the Job Editor window.
Drag the Aggregation transformation onto the process flow diagram.
Connect a source table to the transformation.

To perform the preceding preliminary steps, do the following:

Locate the job that you want to contain this Aggregation transformation. From the IT Data Marts tree, navigate to the IT data mart and folder that contains the job that you want to use. Double-click the job to open it on the Diagram tab of the Job Editor window.

If you want to create a new job, see Jobs That Process IT Data.
Navigate to the Transformations tree and expand ITRM Transformations.
Drag and drop the Aggregation transformation onto the process flow diagram.

Note: A job can contain multiple Aggregation transformations.
Drag and drop a source table onto the process flow diagram and using the cursor, connect the table to the left side of the aggregation image.

Note: The source table is usually a staged table, but it can be any SAS table.
Right-click the aggregation image and, from the drop-down menu that is displayed, select Add Aggregation Table.
Select the type of aggregation table that you want to create. (If you click Cancel on any page of an aggregation wizard, a confirmation dialog box is displayed. If you do not want to cancel, click No.)
- Select Summarized Aggregation Table to invoke the Summarized Aggregation wizard. For information about using this wizard, see Creating Aggregation Tables with the Summarized Aggregation Table Wizard.
- Select Simple Aggregation Table to invoke the Simple Aggregation wizard. For information about using this wizard, see Creating an Aggregation Table with the Simple Aggregation Table Wizard.
- Select Aggregations through Template to invoke the Aggregations through Template wizard. For information about using this wizard, see Creating Aggregation Tables with the Aggregations through Templates Wizard.
Note: You can create summarized aggregation tables multiple times. The aggregation wizard provides a unique suffix for each table that is recreated. Joined columns that are required for the new table are generated from the columns in the new table.