SAS Data Integration Studio P33:This manual is a companion to the online Help for SAS Data Integration Studio. The Help describes all windows in SAS Data Integration Studio, and it summarizes the main tasks that you can perform with the software. The Help includes examples for all source designer wizards, all target designer wizards, and all transformation templates in the Process Library tree. | Example Process Flows A Configure the SQL Join Transformation 155 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. a 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 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. 156 Configure the SQL Join Transformation A Chapter 10 2 Click the Mapping tab. By default the SQL Join transformation maps all columns in the source tables to the same columns in the temporary output table as shown in the following display. Display SQL Join Mapping Tab Before Extra Columns Are Deleted However you need only some of these columns for the report that you want to create. You can simplify the .
