Databases Reference
In-Depth Information
Transformation Properties Window
Use a transformation properties window to view or update the metadata for a process
in a job. The metadata for a transformation specifies how SAS Data Integration Studio
will generate code for the corresponding process. The window for each kind of
transformation has one or more tabs that are unique to the corresponding process. The
following display shows a typical window.
Display 3.12
Transformation Properties Window
The window shown in the previous display contains the metadata for the SAS Sort
transformation from “Process Flows and Jobs” on page 6. Note that the rows in the
output table for this transformation will be sorted by employee ID. For a summary of
how to use transformation property windows, see “Updating Metadata for
Transformations” on page 108 and “Viewing Metadata for Transformations” on page 113.
View Data Window
In the tree views on the desktop, use the View Data window to display data in a SAS
table or view, in an external file, or in a DBMS table or view that is part of a SAS
library for DBMS data stores. The table, view, or external file must be registered in a
current metadata repository and must exist in physical storage.
In the Process Designer window for a job, use the View Data window to display data
in the temporary output tables for a transformation. In order for the temporary output
tables to exist in physical storage, the transformation must be one of the
transformations that create temporary output tables, and the transformation must have
been executed at least once
The View Data window typically uses the metadata for a data store to format the
data for display. Accordingly, the View Data window can be used to verify that the
metadata for a data store is appropriate for use in the intended job. If the window does
not correctly display the data in the selected data store, then you might have to update
the corresponding metadata before you use it in a job.
Search WWH ::
Custom Search