Main Tasks for Users - SAS Data Integration Studio 3.3 User's Guide - page 108

2 From the Project tree, select one or more tables for which you want to update the
metadata and then select Update Table Metadata from the Tools menu.
You might be prompted to supply a user name and password for the relevant
servers When the update is finished, you can choose to view the resulting SAS log.
Updating Metadata for Transformations
Overview
A transformation is a metadata object that specifies how to extract data, transform
data, or load data into data stores. A number of standard transformations are provided
in the Process Library for SAS Data Integration Studio. For a description of the
standard transformations, see Appendix 1, “Standard Transformations in the Process
Library,” on page 217.
There are two main reasons to update the metadata for a transformation:
￿ to update the default metadata for a transformation when it is first added to a job
￿ to change the behavior of a transformation in a process flow
Use the property window for a transformation to update its metadata. For a
description of the transformation properties window, see “Transformation Properties
Window” on page 27.
Update the Default Metadata for a Transformation
When you drag a transformation template from the Process Library and drop it into
the process flow for a job, the default metadata for the transformation is mostly blank.
You must update the default metadata according to your goals for that transformation
in the process flow.
The general steps for updating the default metadata for a transformation are
described in “Update the Job as Needed” on page 100.
Examples of how to update the default metadata for transformation are provided in
Chapter 10, “Example Process Flows,” on page 149. To see more examples of how to
update the default metadata for transformations, follow these steps to display the
relevant Help topics:
1 From the SAS Data Integration Studio menu bar, select Help ￿ Contents . The
online Help window displays.
2 In the left pane of the Help window, select Examples ￿ Process Library
Examples .
Other Updates to the Metadata for a Transformation
After you have made the initial updates to the default metadata for a
transformation, you might have to update the transformation again later. For example,
you might need to change the options on the Options tab for the transformation. The
following steps describe one way to update the metadata for a transformation. Assume
that the metadata for the job that contains the transformation is currently checked into
a change-managed repository.
1 On the SAS Data Integration Studio desktop, select the Inventory tab.
2 In the Inventory tree, expand the Jobs folder.
3 Select the job with the transformation that you want to update, then select
Project ￿ Check Out . The metadata for the job is checked out. A check mark is