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

Step 2. Edit the Parameter File

Step 2. Edit the Parameter File

When you publish the mapping template, Mapping Architect for Visio creates a parameter file in the same location as the Mapping Template XML file. Locate the parameter file and edit it to include the parameter values required for the mappings you want to generate.
In the mapping template you specified the following parameters:
  • $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.
Update the parameter file to create two mapping. Both mappings use the same source, but they extract data different source ports and load data to different ports of the same target. The following code appears in the completed parameter file:
<?xml version='1.0'?> <!DOCTYPE PARAMETERS SYSTEM "parameters.dtd"> <PARAMETERS REPOSITORY_NAME="HR"> <MAPPING NAME="M_EmployeeID" FOLDER_NAME="CRM" DESCRIPTION="M_EmployeeID"> <PARAM NAME="$end$" VALUE="EMPLOYEE_ID" /> <PARAM NAME="$start$" VALUE="EMPLOYEE_NUMBER" /> <PARAM NAME="$Source$" VALUE="s_Employees" /> </MAPPING> <MAPPING NAME="M_EmployeeName" FOLDER_NAME="CRM" DESCRIPTION="M_EmployeeName"> <PARAM NAME="$end$" VALUE="FIRST_NAME" /> <PARAM NAME="$start$" VALUE="EMPL_FIRST_NAME" /> <PARAM NAME="$Source$" VALUE="s_Employees" /> </MAPPING> </PARAMETERS>

0 COMMENTS

We’d like to hear from you!