Mapping Architect for Visio Guide

10.4.0
- 10.5.7
- 10.5.6
- 10.5

Back Next

Importing a Mapping Template from a PowerCenter Mapping

If you have a PowerCenter mapping that you want to use as a basis for a mapping template, export the mapping to a mapping XML file and then use the mapping XML file to create a mapping template.

Export the mapping XML file within the current PowerCenter release. Informatica does not support imported objects from a different release.

To import a mapping template from a PowerCenter mapping, complete the following steps:

Export a PowerCenter mapping.
In the Designer, select the mapping that you want to base the mapping template on and export it to an XML file.

Start Mapping Architect for Visio.

Verify that the Informatica stencil and Informatica toolbar are available
.

Import the mapping.
On the Informatica toolbar, click the Create Template from Mapping XML button. Mapping Architect for Visio determines the mapping objects and links included in the mapping and adds the appropriate objects to the drawing window.

Verify links.
Create or verify links that connect mapping objects.

Configure link rules.
Configure rules for each link in the mapping template to indicate how data moves from one mapping object to another. Use parameters to make the rules flexible.

Configure the mapping objects.
Add a group or expression required by the transformations in the mapping template. To create multiple mappings, set a parameter for the source or target definition.

Declare mapping parameters and variables to use when you run the session in PowerCenter.
After you import the mappings created from the mapping template into PowerCenter, you can use the mapping parameters and variables in the session or workflow.

If the PowerCenter mapping contains mapping parameters and variables, it is possible that the mapping parameters and variables ($$ParameterName
) may not work for all mappings you plan to create from the mapping template. Modify or declare new mapping parameters and variables appropriate for running the new mappings created from the mapping template.

Validate the mapping template.

Save the mapping template.
Save changes to the mapping template drawing file.

Publish the mapping template.
When you publish the mapping template, Mapping Architect for Visio generates a mapping template XML file and a mapping template parameter file (param.xml).

If you make any change to the mapping template after publishing, you need to publish the mapping template again. Do not edit the mapping template XML file.

Mapping Architect for Visio fails to create a mapping template if you import a mapping that includes an unsupported source type, target type, or mapping object.

Rename Saved Search

Table of Contents

Mapping Architect for Visio Guide

Mapping Architect for Visio Guide

Importing a Mapping Template from a PowerCenter Mapping

Importing a Mapping Template from a PowerCenter Mapping