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

2 In the properties window, click the Mapping tab.
3 On the Mapping tab, position the cursor on the name of the source column
Total_Retail_Price , then click and drag the mapping arrow to the target
column Total_Revenue . These two columns are now mapped. The Mapping tab
should resemble the following display.
Display 10.10 Column Mapping in the Loader
4 In the properties window, click the Load Technique tab. Select the Drop Target
radio button to replace the physical table each time the job is run.
The Loader is now configured and is ready to run.
Run the Job and Check the Log
At this point, you have a process flow that will join two source tables, extract
information from columns, calculate total sales revenue for each employee, and write
the results to the Total_Sales_By_Employee table. Before you add a transformation that
will produce the desired report, you might want to verify that the current process flow
will produce the information that is required in the report.
1 With the job displayed in the Process Designer window, select Process ￿ Submit
from the menu bar. SAS Data Integration Studio generates code for the job and
submits the code to a SAS application server. The server executes the code. A
pop-up window displays to indicate that the job is running.
2 If a pop-up error message appears, or if you want to look at the log for the
completed job, click the Log tab in the Process Designer window.
3 On the Log tab, scroll through the SAS log information that was generated during
the execution of the job.
The code that was executed for the job is available on the Source Code tab in
the Process Designer window.
4 If you find errors in the source code for a step, select the corresponding
transformation in the process flow diagram, then select File ￿ Properties from
the menu bar. A properties window displays.