Example Process Flows - SAS Data Integration Studio 3.3 User's Guide - page 151

SAS Tables” on page 140, and (b) the metadata for the table must be updated for
the current job. When you are finished with the current job, metadata for the new
job and the updated metadata for the Total_Sales_By_Employee table will be
checked in. For details about change management, see “Working with Change
Management” on page 113.
￿ It is assumed that you have started SAS Data Integration Studio and have opened
the appropriate metadata profile.
The first task is to check out any existing metadata that must be updated for the
current job.
Check Out Existing Metadata That Must Be Updated
You do not have to check out the metadata for a table in order to add it as a source or
a target in a job. However, the metadata for the Total_Sales_By_Employee table must
be checked out because its metadata must be updated for the current job. The
Total_Retail_Price column in the table must be updated so that it summarizes a total
revenue number from individual sales.
Follow these steps to check out existing metadata:
1 On the SAS Data Integration Studio desktop, select the Inventory tree.
2 In the Inventory tree, open the Tables folder.
3 Select the table that must be updated for the current job:
Total_Sales_By_Employee.
4 Select Project ￿ Check Out from the menu bar. The metadata for this table will
be checked out and will appear in the Project tree.
The next task is to create and populate the job. In this example, you will populate
the job in two stages. First, you will create and test the process flow that loads the
Total_Sales_By_Employee table. Then you will add the report generation process to the
end of the flow.
Create the New Job and Specify the Main Process Flow
Follow these steps to populate a job that loads the Total_Sales_By_Employee table.
To populate a job means to create a complete process flow diagram, from sources,
through transformations, to targets.
1 From the SAS Data Integration Studio menu bar, select Tools ￿ Process
Designer . The New Job wizard displays.
2 Enter a name and description for the job. Type the name
Total_Sales_By_Employee , press the TAB key, the enter the description
Generates a report that ranks salespeople by total sales revenue .
3 Click Finish . An empty job will open in the Process Designer window. The job has
now been created and is ready to be populated with two sources, a target, and an
SQL Join transformation.
4 On the SAS Data Integration Studio desktop, click the Process Library tab to
display the Process Library.
5 In the Process Library, open the Data Transforms folder.