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 Rules Overview

Mapping Template Rules Overview

When you create a link between mapping objects, create a set of rules to indicate the movement of data from one mapping object to the next. Every link in a mapping template must have an associated rule set. A rule set can have one or more rules.
The following table describes the rules that you can create in the mapping template:
Rule Name
Description
All Ports
Links all the ports in a mapping object to all the ports in another mapping object.
Datatype
Links all the ports of the selected datatype in a mapping object to all ports of the same datatype in another mapping object.
Dictionary
Links specified starting and ending ports based on the contents of a referenced text file.
Foreign Key
Links all foreign key ports in a mapping object to foreign key ports with the same names in another mapping object.
Named Port
Links all ports with the specified names in a mapping object to ports with the specified name in another mapping object.
Parameter
Replaces the rules on a link with the rules included in the parameter you specify.
Pattern
Links all ports in a mapping object with names that match the specified starting port pattern to all ports in another mapping object with names that match the specified ending port pattern.
Primary Key
Links the primary key port in a mapping object to the primary key port with the same name in another mapping object.
Group Name
Links ports from one group to ports in a different group based on the specfied rules.

0 COMMENTS

We’d like to hear from you!