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

GROUP BY 'ORGANIZATION_DIM'n.'Employee_ID'n,
'ORGANIZATION_DIM'n.'Company'n, 'ORGANIZATION_DIM'n.'Department'n,
'ORGANIZATION_DIM'n.'Section'n, 'ORGANIZATION_DIM'n.'Org_Group'n,
'ORGANIZATION_DIM'n.'Job_Title'n, 'ORGANIZATION_DIM'n.'Employee_Name'n
5 The updates to the SQL Join transformation are complete. Click OK to save your
changes and close the properties window for the transformation.
Update the Metadata for the Total Sales By Employee Table
When the metadata for the Total Sales By Employee table was created, it was not
fully optimized for the report shown in Display 10.1 on page 150. In order to produce
the report, you must make the following changes to the column metadata for the
Total_Sales_By_Employee table:
￿ Rename the Total_Retail_Price column to Total_Revenue to better match the
summarized data that you specified in “Change One Column to a Calculated
Column” on page 157.
￿ Specify formatting for the Total_Revenue column so that its contents will display
properly in the report.
Follow these steps to update column metadata for Total Sales By Employee table:
1 In the Process Designer window, select Total_Sales_By_Employee , then select
File ￿ Properties from the menu bar. A properties window displays.
2 In the properties window, click the Columns tab.
3 Click the Total_Retail_Price column. Change the name to Total_Revenue .
4 In the Total_Revenue column, scroll right to display the Format column. Enter
the format DOLLAR13.2 to specify the appearance of this column in the HTML
output file.
5 In the Total_Revenue column, click twice in the Sort column to display a
pull-down icon. Click the icon and select the DSCFORMATTED option. This
option sorts the rows in descending order, based on the formatted value of the
Total_Revenue column.
6 Click OK to save your changes and close the properties window for the table.
Configure the Loader Transformation
You must make two updates to the Loader transformation for the Total Sales By
Employee table:
￿ On the Mapping tab in the transformation properties window, map the source
table column Total_Retail_Price to the target table column Total_Revenue .
The individual sales figures in the Total_Retail_Price column are summarized
in the Total_Revenue column., so these two columns must be mapped to each
other. The Loader transformation will automatically map source and target
columns with the same name, but not map columns with different names.
￿ On the Load Techniques tab, select the Drop Table option. For SAS tables such
as Total Sales By Employee, the Drop Table option conserves disk space.
Follow these steps to update the Loader transformation for the Total Sales By
Employee table:
1 In the Process Designer window, select the Loader transformation. Then select
File ￿ Properties from the menu bar. A properties window displays.