Working with Aggregation Transformations

Properties of an Aggregation Transformation

To access an Aggregation transformation, from the IT Data Marts tree navigate to the IT data mart that contains the job where the Aggregation transformation is located. Double-click the job to open it on the Diagram tab of the Job Editor window. Right-click the Aggregation transformation and select Properties.
The Properties dialog box appears. It consists of the following tabs:
  • The General tab contains the identifying information about the transformation. The fields on this tab can be modified.
    General Tab of an Aggregation Transformation
    General Tab of an Aggregation Transformation
    The following display shows the General tab of an aggregation table.
    For items in the preceding display, the following definitions apply:
    Name
    identifies the name of the Aggregation transformation.
    Description
    describes the Aggregation transformation.
  • The ITRM Options tab enables you to view, add, modify, and delete filters for an Aggregation transformation. It also enables you to specify that the Aggregation transformation should purge data from the source table after the Aggregation transformation has executed successfully.
    ITRM Options Tab of an Aggregation Transformation
    ITRM Options Tab of an Aggregation Transformation
    Name
    The Name column displays the list of filters that are available for an Aggregation transformation. (You can apply only zero or one filter to an aggregation target table.) A value is required in this field.
    Expression
    The Expression field displays the definition or the calculation of the filter. A value is required in this field.
    New
    Clicking the New option adds a new row in the table that displays all the available filters. This action enables you to specify a filter that can be applied to a table that is input to an Aggregation transformation.
    Delete
    Clicking the Delete option deletes the selected filter.
    Purge source table after the successful execution of this transformation
    Checking the Purge source table after the successful execution of this transformation option removes the data from the source table after the aggregation tables are processed.
  • The Code tab contains the code that is generated for the transformation.
  • The Precode and Postcode tab contains information about user-written code that might be inserted at the beginning or the end of the transformation.
  • The Parameters tab contains information about prompts.
  • The Notes tab contains areas where you can annotate the table.
  • The Extended Attributes tab contains a custom property that is not part of the metadata for the transformation.
    The following display shows the Extended Attributes tab of an aggregation table.
    Extended Attributes Tab of an Aggregation Transformation
    Extended Attributes Tab of an Aggregation Transformation
    For items in the preceding display, the following definitions apply:
    New icon
    adds a row to the attribute table. A number and a default name are provided, but you must enter the value and description.
    Up icon
    if present, enables you to reorder rows by moving a selected row up in the table.
    Down icon
    if present, enables you to reorder rows by moving a selected row down in the table.
    Delete icon
    deletes a selected attribute from the list.
    #
    specifies the number of the extended attribute.
    Field Name
    specifies the attribute name to be defined.
    Value
    specifies the value for the attribute that is specified in the Field Name column.
    Description
    describes the attribute and value.

Delete an Aggregation Transformation from a Job

A job can consist of multiple transformations. An Aggregation transformation can consist of multiple aggregations, each generating an aggregation table. To delete an Aggregation transformation from a job, perform the following steps:
  1. Locate the Aggregation transformation that you want to delete. To do so, from the IT Data Marts tree, navigate to the IT data mart that contains the job where the Aggregation transformation is located. Double-click the job to open it on the Diagram tab of the Job Editor window.
  2. Right-click the box that represents the Aggregation transformation that you want to delete.
  3. From the drop-down menu, select Delete.
Note: If you delete an Aggregation transformation, the target tables that were populated by those aggregations are not deleted. However, the tables are no longer updated.

Rename an Aggregation Transformation

  1. Locate the Aggregation transformation that you want to rename. To do so, from the IT Data Marts tree, navigate to the IT data mart that contains the job where the Aggregation transformation is located. Double-click the job to open it on the Diagram tab of the Job Editor window.
  2. Right-click the Aggregation transformation box.
  3. From the drop-down menu, select Properties.
  4. On the General tab, enter the new name of the Aggregation transformation.
  5. Click OK to save your changes and return to the process flow diagram.
Note: Renaming an Aggregation transformation does not rename the aggregation tables that it generates.
Copyright © SAS Institute Inc. All rights reserved.