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

CHAPTER

10

Example Process Flows

Using Jobs to Create Process Flows 149
Example: Creating a Job That Joins Two Tables and Generates a Report 150

Preparation 150
Check Out Existing Metadata That Must Be Updated 151
Create the New Job and Specify the Main Process Flow 151
(Optional) Reduce the Amount of Data Processed by the Job

153

Configure the SQL Join Transformation 155

Specify Column Mappings 155
Change One Column to a Calculated Column

157

Specify GROUP BY Options for the Join 160
Update the Metadata for the Total Sales By Employee Table 161

Configure the Loader Transformation 161

Run the Job and Check the Log 162
Verify the Contents of the Total_Sales_By_Employee Table 163
Add the Publish to Archive Transformation to the Process Flow 163

Configure the Publish to Archive Transformation 166

Run the Job and Check the Log 166

Check the HTML Report 167
Check In the Metadata 167
Example: Creating a Data Validation Job 167

Preparation 167
Create and Populate the New Job 168
Configure the Data Validation Transformation 170

Run the Job and Check the Log

172

Verify Job Outputs 173
Example: Using a Generated Transformation in a Job 174

Preparation 174
Create and Populate the New Job 175
Configure the PrintHittingStatistics Transformation 176

Run the Job and Check the Log 178

Verify Job Outputs 179
Check In the Metadata

179

Using Jobs to Create Process Flows

After you have specified the metadata for one or more sources and targets, you can
specify metadata for the job that will read the appropriate sources and create the
desired targets in physical storage. Use the examples in this chapter, together with the
general steps that are described in “Creating, Running, and Verifying Jobs” on page 99,
to specify jobs that will create and load the desired targets.