Mapping Configuration
Use the Mapping Designer to configure a mapping.
To configure a mapping, perform the following tasks:
- 1. Define the mapping.
- 2. Configure the data flow. Add and configure transformations, and draw links to represent the flow of data.
- 3. Optionally, create parameters to be defined in the Mapping Configuration task.
- 4. Save and validate the mapping.
Mapping Validation and Error Handling
When you save a mapping, the Mapping Designer validates the mapping. You can view error details in the Validation panel.
When you save a mapping, the status area indicates when the mapping is valid. When a mapping is not valid, you can use the Validation panel to view the location and details of mapping errors.
The Validation panel displays a list of transformations in a mapping. To open the Validation panel, in the toolbar, click the Validation icon. In the Validation panel, click Validate. Error icons display by the transformations that include errors. To view the details about the error, click the error icon. To display all errors in a list, use the Show All Errors option.
Run Mapping
You can perform a test run of a valid mapping to verify the results of the mapping before you create a Mapping Configuration task.
When you perform a test run, you run a temporary Mapping Configuration task. The task reads source data, writes target data, and performs all calculations in the data flow. When the mapping includes parameters, the Mapping Configuration Task wizard displays, requesting values for the parameters.
The Mapping Configuration task discards the temporary task after the test run.
You can test run a mapping from the Mapping Designer. You can also test run a mapping from the Mappings page.
Mapping Updates and Deployment
Deploy a mapping to a Mapping Configuration task when you want the task to use the updated mapping.
After you update a mapping used in Mapping Configuration tasks, you have the following choices:
- •Save your changes as a new mapping. Use this option when you want to keep the previous version of the mapping and related Mapping Configuration tasks.
- •Save your changes and deploy the mapping to Mapping Configuration tasks. Use this option when your changes are compatible with the existing tasks. You might need to edit the tasks to verify that they are valid with the new version of the mapping.
You can view the last deployed version of the mapping. You can also revert to the last deployed version of the mapping.
Rules and Guidelines for Mapping Configuration
Use the following rules and guidelines when you configure a mapping:
- •A mapping does not need a Source transformation if it includes a Mapplet transformation and the mapplet includes a source.
- •You can use multiple branches within the data flow, but create a single data flow between sources and targets. Do not use parallel data flows in a mapping.
- •Connect all transformations to the data flow.
- •You can merge multiple upstream branches through a passive transformation only when all transformations in the branches are passive.
- •When you rename fields, update conditions and expressions that use the fields. Conditions and expressions, such as a Lookup condition or expression in an Expression transformation, do not inherit field name changes.
- •To use a connection parameter and a specific object, use a connection and object in the mapping. When the mapping is complete, you can replace the connection with a parameter.
- •When you use a parameter for an object, use parameters for all conditions or field mappings in the data flow that use fields from the object.
Configuring a Mapping
Use the Mapping Designer to configure a mapping.
1. To create a mapping, click Design > Mappings, and then click New Mapping.
To edit a mapping, in the Actions column for the mapping, click Edit Mapping.
2. In the New Mapping dialog box, enter the mapping name and description, and click OK.
Mapping names can contain alphanumeric characters and underscores (_). Maximum length is 128 characters.
The following reserved words cannot be used:
- - AND
- - OR
- - NOT
- - PROC_RESULT
- - SPOUTPUT
- - NULL
- - TRUE
- - FALSE
- - DD_INSERT
- - DD_UPDATE
- - DD_DELETE
- - DD_REJECT
- - SYSDATE
- - SESSSTARTTIME
Description is optional. The maximum length is 1024 characters.
3. To configure a source, on the Transformation palette, click Source.
- a. In the Properties panel, on the General tab, enter a name for the transformation..
Transformation names can contain alphanumeric characters and underscores (_). Maximum length is 200 characters.
The following reserved words cannot be used:
- ▪ AND
- ▪ OR
- ▪ NOT
- ▪ PROC_RESULT
- ▪ SPOUTPUT
- ▪ NULL
- ▪ TRUE
- ▪ FALSE
- ▪ DD_INSERT
- ▪ DD_UPDATE
- ▪ DD_DELETE
- ▪ DD_REJECT
- ▪ SYSDATE
- ▪ SESSSTARTTIME
- b. Optionally, enter a description of the transformation.
Maximum length is 4000 characters.
- c. Click the Source tab and configure source details. When available, configure the advanced source properties.
Source details, query options, and advanced source properties appear based on the connection type. For more information, see Transformations.
For some connections, you can select Multiple Objects to add related objects. Select a primary object and add related objects from the Actions menu.
To configure a source filter or sort options, expand Query Options. Click Configure to configure a filter or sort option.
- d. To add or remove source fields, to update field metadata, or to synchronize fields with the source, click the Fields tab.
- e. To save your changes and continue, in the toolbar, click Save > Save and Continue.
- f. To add another Source transformation, repeat these steps.
4. To add a transformation, on the Transformation palette, click the transformation name. Or, drag the transformation onto the mapping canvas.
- a. On the General tab, enter a name and description for the transformation.
- b. Draw a link to connect the previous transformation to the transformation.
When you link transformations, the downstream transformation inherits the incoming fields from the previous transformation.
For a Joiner transformation, draw a master link and a detail link.
- c. To preview fields, configure the field rules, or rename fields, click Incoming Fields.
- d. Configure additional transformation properties, as needed.
The properties that you configure vary based on the type of transformation you create.
- e. To save your changes and continue, click Save > Save and Continue.
- f. To add another transformation, repeat these steps.
5. To add a Target transformation, on the Transformation palette, click Target.
- a. On the General tab, enter a name and description.
- b. Draw a link to connect the previous transformation to the Target transformation.
- c. Click the Target tab and configure target details. If necessary, configure the advanced target properties.
Target details and advanced target properties display based on the connection type. For more information, see Transformations.
- d. To preview fields, configure the field rules, or rename fields, click Incoming Fields.
- e. Click Field Mapping and map the fields that you want to write to the target.
- f. To add another Target transformation, repeat these steps.
6. To save your changes and continue, click Save > Save and Continue.
7. To save and close the mapping, click Save > Save and Close.