Databases Reference
In-Depth Information
The number that you specify in the OBS= option should be high enough so that
the transformations in the job will be able to execute successfully; that is, the
transformations will have enough data on which to perform their operations.
7
Click
OK
to save the OBS= option.
8
Click
OK
to save your changes in the job properties window.
Note:
All inputs in the current job will be limited to the number of data rows that
you specified in the OBS= option until you disable this option.
One way to disable a pre-processing option is to (a) deselect the
Pre Processing
check box on the
Pre and Post Process
tab, and (b) save the job and close the
Process Designer window. For more information about setting options on the
Pre and
Post Process
tab in the job properties window, see “Adding SAS Code to the Pre and
Post Processing Tab” on page 225.
Configure the SQL Join Transformation
Specify Column Mappings
In this section, you will map some columns from the source tables to columns in the
temporary output table for the SQL Join transformation. The goal is to map only the
columns that are required for the report that you want to create, as shown in Display
10.1 on page 150. The required columns are Employee_Name, Employee_ID, Job_Title,
Company, Department, Section, Org_Group, and Total_Retail_Price.
Follow these steps to specify column mappings for the SQL Join transformation:
1
In the Process Designer window, select the
SQL Join
transformation object. Then
select
File
Properties
from the menu bar. A properties window displays.
Search WWH ::
Custom Search