Deleting an Aggregation Table :: SAS(R) IT Resource Management 3.7: Administrator's Guide

Delete an Aggregation Table from an Aggregation Transformation

To delete an aggregation table from an Aggregation transformation, perform the following steps:

Locate the Aggregation transformation that generates the aggregation table 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.
Right-click the aggregation table that you want to delete.
From the drop-down list, select Delete. The table is removed from the Aggregation transformation that is displayed in the process flow diagram. However, the metadata for that table and the library are not deleted from the IT data mart. For information about this topic, see Delete an Aggregation Table from the IT Data Mart.

In order for your changes to take effect, you must redeploy the job. For information about redeploying jobs, see Redeploy All Jobs on the Server.

CAUTION:

To avoid processing errors, delete any reference to this table, as a source or target for any transformation in any other job.

For example, Information Map transformations that use the deleted table as a source table should be deleted.

Delete an Aggregation Table from the IT Data Mart

To delete an aggregation table from an IT data mart, perform the following steps:

Locate the aggregation table 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 table is generated.
Expand that IT data mart and navigate to the aggregation table that you want to delete. Right-click the table.
From the drop-down list, select Delete.
Click Yes to confirm that you want to delete this table. The table is removed from the IT data mart. However, the associated library is not deleted.

Note: This delete action does not delete the physical table. It deletes the metadata of the table.

CAUTION:

Deleting a table can break join columns if the table that you delete is the source for another table.

Erase an Aggregation Table

Erasing an aggregation table deletes the physical table, its contents, and its metadata. To erase an aggregation table, perform the following steps:

In a tree view of SAS IT Resource Management, locate the aggregation table that you want to erase.
Right-click the aggregation table that you want to erase. The aggregation job that includes the aggregation table must be closed and currently not in use before erasing.
Select Erase.
Click Yes to confirm that you want to erase this aggregation table.

CAUTION:

If you erase an aggregation table that serves as a source table in other jobs, then these associated jobs might not execute because they are missing a source table.

Simply erasing an aggregation table does not affect the metadata of the associated aggregation or information map jobs. However, if you erase an aggregation table and rerun the aggregation job, then the data for the deleted aggregation table is not created. In addition, the jobs that used that table will fail due to a missing source table.