Updating the Metadata for a Table

---

Perform the following steps to update the metadata for a table that is under change management.

1. On the SAS ETL Studio desktop, select the Inventory tree.

2. In the Inventory tree, open the Tables folder or the External Tables folder.

3. Select the table, then select Project Check Out. The metadata for the table is checked out. A check mark is displayed next to the table in the Inventory tree. An icon indicating a checked-out table appears in the Project tree.

4. Display the Project tree, select the table, and select File Properties from the menu bar. The properties window for the table is displayed.

   Note that you must display the table from the Project tree in order to update metadata. Displaying the table from the Inventory tree enables browsing only.

5. Use the tabs in this window to make changes to the metadata for the table. Each tab has its own Help button. Column metadata is a special case. For details, see "Updating Column and Mapping Metadata" on page 68.

6. When you are finished updating the metadata, you can check in your changes. In the Project tree, select the repository icon.

7. From the menu bar on the SAS ETL Studio desktop, select Project Check In Repository.

Impact of Updating a Table's Metadata

Keep in mind that a table can be used in multiple jobs. A table can also be used in multiple places in the same job. Accordingly, when you update the metadata for a table, make sure that the updates are appropriate in all contexts where the metadata is used. For example, if you update the columns for Table 1 in one job, the updates would also have to be appropriate for Table 1 in the context of another job.

Updating Column and Mapping Metadata

If the metadata for a source has not yet been added to a job, you can update its column metadata as previously described. If the metadata for a source has been added to a job, the job might have one or more targets and transformations that depend on the current column metadata for the source. In that case, use the steps that are described in "Updating Column and Mapping Metadata" on page 119.

---