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. Glossary

Mapping Architect for Visio Guide

Mapping Architect for Visio Guide

Step 2. Specify Parameters in the Mapping Template

Step 2. Specify Parameters in the Mapping Template

After you select the mapping template, use parameters to create two mappings. The parameters that you defined in the mapping template appear in the wizard.
You configured the following parameters in the mapping template:
  • $end$
    . This parameter defines the target port.
  • $start$
    . This parameter defines the source port that contains the data required in the target.
  • $Source$
    . This parameter defines the source table.
Create two mappings with different values for the $end$ and $start$ fields. Enter the same value for the $source$ field.
The following example shows the settings for the two mappings you want to create, one listing for M_EmployeeID and another for M_EmployeeName:
These settings create two mappings that use the same source table, but extract different data and load the data to different ports of the same target table.
The Source table list shows available sources in the following format:
DBDName:SouceTableName

0 COMMENTS

We’d like to hear from you!