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

Including or Excluding Rules

Including or Excluding Rules

When you create a rule, you can include or exclude ports that conform to a rule. If you include ports, Mapping Architect for Visio creates a link for all the starting ports that conform to the rule. If you create more than one rule in a rule set, Mapping Architect for Visio creates links for the list of starting ports that conform to rules, based on the order of the rules.
You can also create rules to exclude ports from the list. The order in which an exclusion rule appears in a rule set is important. An exclusion rule can exclude ports only from the list of included ports. Therefore, an exclusion rule is valid only when it follows one or more rules that create links for ports. You cannot set up a rule set that contains only an exclusion rule. You cannot create a rule set where the first rule is an exclusion rule.
Based on the example ports in Rule Order, Mapping Architect for Visio creates links for the sample rule sets.
The following table shows how Mapping Architect for Visio evaluates the rules in rule sets that contain exclusion rules:
This rule set...
Creates these links...
All Ports
Named:ITEM_DESC (TO) DESCRIPTION
Named:PRICE (TO) ITEM_PRICE
DataType:decimal
EXCLUDE Foreign Key
ITEM_ID links to ITEM_ID
ITEM_NAME links to ITEM_NAME
ITEM_DESC links to DESCRIPTION
PRICE links to PRICE
DISCONTINUED_FLAG links to DISCONTINUED_FLAG
The All Ports rule creates links for all ports. The Named Port rules for ITEM_DESC and PRICE override the All Ports rule. The Datatype rule overrides the Named Port rule for PRICE. The Exclude Foreign Key rule removes the links for the foreign key ports.
Named:ITEM_DESC (TO) DESCRIPTION
Named:PRICE (TO) ITEM_PRICE
EXCLUDE Pattern:^ITEM.*$ (TO) $0
PRICE links to ITEM_PRICE
The Named Port rules create links for ITEM_DESC and PRICE. However, the Exclude Pattern rule removes the link for ports that start with the string
ITEM
.
Pattern:^ITEM.*_.*$ (TO) $0_IN
EXCLUDE Primary Key
Foreign Key
ITEM_NAME links to ITEM_NAME_IN
ITEM_DESC links to ITEM_DESC_IN
MANUFACTURER_ID links to MANUFACTURER_ID
DISTRIBUTOR_ID links to DISTRIBUTOR_ID
The Pattern rule creates links for ITEM_ID, ITEM_NAME, and ITEM_DESC. However, the Exclude Primary Key rule removes the link for ITEM_ID. The Foreign Key rule creates links for MANUFACTURER_ID and DISTRIBUTOR_ID.

0 COMMENTS

We’d like to hear from you!