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

and creates targets in physical storage. After you have entered metadata for sources
and targets, you are ready to create jobs.
Prerequisites
It is easier to create a job if metadata for the tables in the job are created first. For
details about these tasks, see Chapter 8, “Registering Data Sources,” on page 119 and
Chapter 9, “Registering Data Targets,” on page 139.
Check Out Existing Metadata That Must Be Updated
As you work on the current job, will you update the metadata for any registered
tables? If so, you must check out the metadata for that table.
For example, suppose that you want to create a job in which data is extracted from a
registered table and then is written to a report. In this case, the metadata for the table
is not changed, so you would not have to check out the metadata. However, suppose
that you want to create a job that require you to add three new columns to the
metadata for a registered table. In that case, the metadata for the table is changed, so
you would need to check out the metadata.
The next task is to create and populate the job.
Create and Populate the New Job
Follow these steps to create and populate a new job. To populate a job, you will create
a complete process flow diagram, from sources, through transformations, to targets.
1 On the SAS Data Integration Studio desktop, select Tools ￿ Process Designer
from the menu bar. The New Job wizard displays. (You can use this wizard to
create an empty job, into which you can drag and drop tables and transformations.
That is the approach that is described here.)
2 Enter a name for the job and click Finish .
3 An empty job will open in the Process Designer window.
4 Add metadata for sources, targets, and transformations as needed. The goal is to
create a complete process flow diagram, from sources, through transformations, to
targets. Drag and drop transformation templates from the Process Library tree.
Drag and drop tables from the Inventory tree or from another tree in the tree
view. If you try to drop an object in a zone where it is invalid, an error message
will be written to the Status bar at the bottom of the SAS Data Integration Studio
desktop.
As you add sources, targets, and transformations to a process flow diagram, SAS
Data Integration Studio automatically maps source columns to target columns.
Depending on the nature of the job, you might or might not need to update the
automatic column mappings or the other default metadata in a job.
The next task is to view or update the job, as needed.
Update the Job as Needed
The following steps describe a general approach for updating the default metadata in
a job. The specific updates will vary according to the sources, targets, and
transformations in a job and the purpose of the job. The examples in Chapter 10,
“Example Process Flows,” on page 149 describe scenarios in which a few, specific updates
are needed to the automatic column mappings and the other default metadata in a job.
1 In the Process Designer window, select the first source in the flow, then select File
￿ Properties from the menu bar. A properties window displays.