Maintaining Processes

Example: Defining Mapping Process Properties for One-to-One Mapping

This example defines the Mapping process properties for a one-to-one column mapping, which is one input source to one output table. The properties also specify that SAS/Warehouse Administrator will generate the Mapping process code.

Note: The following explanation describes the metadata and methods used to achieve the desired results. It is assumed that the appropriate Data Warehouse Environment, Data Warehouse, Subject, data stores, Job, and Process Flow exist. [cautionend]

Defining Mapping Properties

For most output tables, a default Mapping process will appear between the output table and an input source after you add the input source to a Job Process Flow as shown in the following Process Flow:

[untitled graphic]

You must always update the default metadata in order for the Mapping process to work. In the Job Process Flow, position the cursor on the Mapping process icon, click the right mouse button, and select Properties. The Mapping Process Properties window displays.

General Tab	specifies a name, for example Customer Mapping, a description, an owner, and an administrator for the Mapping process.
Source Code Tab	specifies who generates the code for the Mapping process, which for this example is SAS/Warehouse Administrator.
Execution Tab	specifies the host on which you want to run the Mapping process, which for this example is the local host.
Output Data Tab	specifies the name and location of the intermediate work table(s) produced by the Mapping process.
Column Mapping Tab	defines how input columns are mapped into the output table(s) and, if specified, how the data in those columns is transformed. To define mappings, you can click either 1 to 1 Mappings, which opens the One-to-One Column Mapping window, or Derive Mapping, which opens the Expression Builder window. This example selects 1 to 1 Mappings, which enables you to define mappings that do not include data transformations as follows: In the One-to-One Column Mapping window, click Quick Map and then OK. Column names from the source column list are mapped to the target column list and are displayed in the mapping list on the right of the window as follows: Click OK to return to the Column Mapping tab in the Mapping Process Properties window, which displays the mapped columns.
Where Tab	specifies a condition that the data must satisfy before SAS reads it, which for this example is not specified.

The following window shows some of the generated code for the Mapping process:

[untitled graphic]

Top of Page