You can
access the properties window for the table and change the settings
on the appropriate tab of the window. The following tabs are available
on properties windows for tables:
Use the
properties window for a table to view or update the metadata for its
columns, keys, indexes, and other attributes. You can right-click
a table in any of the trees on the SAS Data Integration Studio desktop
or in the
Job Editor window. Then, click
Properties to access its properties window.
Note that
updates that you make to the metadata about the table affect all other
users of that table's metadata. However, the physical table is not
actually updated until you run a job process that actually updates
that table. In the case of existing physical tables, in order to make
the physical table match the metadata, it is necessary to drop and
recreate the table. These changes can have the following consequences
for any jobs that use the table:
-
Changes, additions, or deletions
to column metadata are reflected in all of the jobs that include the
table.
-
Changes to column metadata often
affect mappings. Therefore, you might need to remap your columns.
-
Changes to keys, indexes, physical
storage options, and parameters affect the physical external file
and are reflected in any job that the includes the table.
You can use the impact analysis and reverse impact
tools in SAS Data Integration Studio to estimate the impact of these
updates on your existing jobs.