CAUTION:
You can
change the name of the physical aggregation table only by using the
Edit Aggregation wizard.
Changing the name
of the table on the
General tab of the
Properties dialog
box does not change the name of the physical table.
To rename a simple
or a summarized aggregation table, perform the following steps:
-
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.
-
Right-click the aggregation
table that you want to rename.
-
From the drop-down list,
select
Edit <aggregation-type>
Aggregation Table, where
aggregation-type is
Summarized or Simple. This action opens the
Summarized
Aggregation Table wizard or the
Simple Aggregation
Table wizard.
-
To change the name of
the table in the metadata, enter the new name of the aggregation table
in the
Name field on the first page of the
wizard.
To change the name of
the physical table, enter the new name of the aggregation table in
the
SAS Table Name field.
-
Click
Next to
proceed through all the pages of the wizard. Then click
Finish.
-
Click
OK to
save your changes and return to the process flow diagram.
Note: This task changes the name
of the table in the metadata. The name of the physical SAS data set
is changed when you click
Finish. In
order for your changes to take effect, you must redeploy the aggregation
job. In addition, even though the metadata linkage to that renamed
table still exists, it is advisable to redeploy the information map
job that uses the renamed table as input.
For more information
about redeploying jobs, see Redeploy All Jobs on the Server.