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

Pattern

Pattern

The Pattern rule 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. Do not include spaces in port pattern names.
To create a Pattern rule, use a regular expression pattern. A regular expression is a specialized formula for matching text strings that follow a pattern. Create a Pattern rule only if you are familiar with the regular expression syntax.
The following table shows examples of regular expression patterns and the port names that match the patterns:
Regular Expression Pattern
Example Port Names that Match or Do Not Match the Pattern
Starting Port Pattern: _IN$
Ending Port Pattern: <blank>
GENDER_IN links to GENDER.
ETHNIC_GROUP_IN links to ETHNIC_GROUP.
EMPLOYEE_ID and EMPLOYEE_NAME do not match the starting port pattern.
Starting Port Pattern: ^EMP.*_.*$
Ending Port Pattern: $0
EMPLOYEE_ID links to EMPLOYEE_ID.
EMPLOYEE_NAME links to EMPLOYEE_NAME.
GENDER and ETHNIC_GROUP do not match the starting port pattern.
Starting Port Pattern: ^EMP.*_.*$
Ending Port Pattern: $0_IN
EMPLOYEE_ID links to EMPLOYEE_ID_IN.
EMPLOYEE_NAME links to EMPLOYEE_NAME_IN.
GENDER and ETHNIC_GROUP do not match the starting port pattern.
Starting Port Pattern: [\d]$
Ending Port Pattern: $0
EMPLOYEE_NAME1 links to EMPLOYEE_NAME1.
GENDER1 links to GENDER1.
EMPLOYEE_ID and ETHNIC_GROUP do not match the starting port pattern.
Starting Port Patterns:

    [A-Za-z_][A-Za-z_0-9]*

    [A-Za-z_0-9]+

    [A-Za-z_][A-Za-z_0-9]+

Ending Port Pattern: $0 _x
EMPLOYEE_ID links to EMPLOYEE_ID_x.
EMPLOYEE_NAME links to EMPLOYEE_NAME_x.
GENDER links to GENDER_x.
ETHNIC_GROUP links to ETHNIC_GROUP_x.

Syntax

Use the following syntax when you include this rule in a Parameter rule:
Pattern:<
StartingPortPatternString
> (TO) <
EndingPortPatternString
>

0 COMMENTS

We’d like to hear from you!