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

Running the mapgen Command Line Program

Running the mapgen Command Line Program

Use the
mapgen
command line program to create the mappings from a mapping template.
mapgen
uses the following syntax:
mapgen <-t> VisioDrawingFile <-p> ParameterFile <-o> MappingFile [-d] TableDefinitionDir
The following table describes the
mapgen
options and arguments:
Option
Argument
Required/
Optional
Description
-t
VisioDrawingFile
Required
Name of the Visio drawing file for the mapping template. The file has a .vsd extension for Microsoft Visio 2010 and previous versions. You can save the file with a .vsdx extension for Microsoft Visio 2016. To create the file, save the mapping template in Mapping Architect for Visio as a Visio drawing file.
If the file is not in the current working folder, add a path name in front of the file name.
-p
ParameterFile
Required
Name of the mapping template parameter file. Mapping Architect for Visio automatically creates the parameter file when you publish the mapping template. The filename is <mapping template name>_param.xml. If the file is not in the current working folder, add a path name in front of the file name.
-o
MappingFile
Required
Name of the PowerCenter mapping file used to create mappings from the mapping template. The file has a .xml extension. If you do not want to create the file in the current working folder, add a path name in front of the file name.
-d
TableDefinitionDir
Conditional
Name of the folder where the source and target definition files are located. Required if the files are not located in the default folder.
By default, the source and target definition files are stored in the following location:
\<
PowerCenterInstallationDir
>\Clien
t\
MappingTemplate\tabledefs
Before you run
mapgen
, verify that you have all the files required by the program.
To run the mapgen program:
  1. Close the referenced Visio drawing file.
    If the .vsd or .vsdx file is open when you run
    mapgen
    ,
    mapgen
    generates a warning that the file is open for modification.
  2. In the Designer or Repository Manager, export the source and target definitions for the sources and targets you want to use in the mappings to be created by the
    mapgen
    program.
    By default,
    mapgen
    looks for the source and target definition files in the following folder:
    <
    PowerCenterInstallationDir
    >\client\MappingTemplate\tabledefs
    If you export the files to another folder, provide the folder name when you run the
    mapgen
    program.
  3. Open a command line window on the machine where Mapping Architect for Visio is installed.
  4. Go to the Mapping Architect for Visio folder.
    By default, Mapping Architect for Visio is installed in the following location:
    <
    PowerCenterInstallationDir
    >\client\MappingTemplate\
  5. Run mapgen.exe.
    After you generate the mapping file, import the file into the repository to view all the generated mappings.

0 COMMENTS

We’d like to hear from you!