Purging Contents of an Aggregation Table

Purge Data from an Aggregation Table from the Process Flow Diagram

To purge data from an aggregation table, perform the following steps:
  1. Locate the Aggregation transformation that generates the aggregation table that you want to modify. 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 table whose data you want to purge.
  3. From the drop-down list, select Purge.
  4. Click Yes to confirm that you want to purge the data from this aggregation table.

Purge Data from an Aggregation Table on the IT Data Marts Tab

You can also purge the contents of an aggregation table by performing the following steps:
  1. Locate the Aggregation transformation that generates the aggregation table that you want to modify. 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.
  2. Right-click the aggregation table whose data you want to purge.
  3. From the drop-down list, select Purge.
  4. Click Yes to confirm that you want to purge the data from this aggregation table.
Copyright © SAS Institute Inc. All rights reserved.