Table of Contents

Search

  1. Preface
  2. Understanding Mapping Architect for Visio
  3. Mapping Templates
  4. Mapping Objects
  5. Mapping Template Rules
  6. Using the Import Mapping Template Wizard
  7. Using the mapgen Command Line Program
  8. Using Informatica Mapping Templates
  9. Appendix A: Glossary

Mapping Architect for Visio Guide

Mapping Architect for Visio Guide

Mapping Template Parameters

Mapping Template Parameters

Use mapping template parameters to configure values for each mapping. You can create more than one mapping from a mapping template. You can use multiple sources and targets with different port names in the mappings. Each mapping you create from the mapping template uses the same mapping objects, but you may need to configure each mapping object in a different way.
When you define a mapping template parameter, enclose the name in dollar signs. For example, you want to create three mappings from one mapping template. Each mapping uses a different source table. When you configure the source definition in the mapping template, you can set the value of the Source Table property to a parameter, such as $Source$. When you specify parameter values, define the three mappings and set the value of the parameter for the source table for each mapping to the specific source table name.
The mapping template parameter ($
ParameterName
$) is not the same as the PowerCenter mapping parameter ($$
ParameterName
).
Mapping template parameter names and values are case sensitive unless otherwise noted. The mapping template parameter name can contain letters, numbers, or underscores (_). Provide a unique name for each parameter. Mapping Architect for Visio does not validate that parameter names are unique in the mapping template. To view a list of all the parameter values in a mapping template, click the Show Parameters button on the Informatica toolbar.
Create parameters to represent the following mapping template components:
  • Mapping object properties.
    To configure a mapping object differently for each mapping, specify parameters when you set the properties.
    If you want to create multiple mappings, set a parameter for either the Source or Target Table property in the source or target definition. You can set parameters for both the Source and Target properties.
  • Expressions.
    You can use a parameter as part of an expression or in place of an expression.
  • Rules.
    You can use a parameter as part of any rule in a link. You can include one or more rules in a parameter.
  • Group names.
    To use different group names for different mappings, specify parameters instead of values when you set the group name.

0 COMMENTS

We’d like to hear from you!