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

Router Transformation

Router Transformation

Use the Router transformation to evaluate data based on one or more conditions and route the rows of data that meet each condition into a separate output group. Optionally, you can route rows of data that do not meet any of the conditions to a default output group.
When you configure a Router transformation, you can define one or more router groups. These groups have the same ports. When you generate mappings from the mapping template, unique numeric suffixes are assigned to the names of the output ports in each group.
The following table describes the required properties for the Router transformation:
Transformation Property
Description
Transformation Name
Name of the transformation.
Group Filter Condition
Returns TRUE or FALSE for each row that passes through the transformation, depending on whether a row satisfies the specified condition.
The suffix follows the order in which the groups are listed in the Router configuration window.
For example, the following table describes the groups that you define for a Router transformation:
Group Name
Group Filter Condition
DEFAULT
OutputPortA1
OutputPortB1
OutputPortC1
LONDON_GROUP
City=”London”
SEATTLE_GROUP
City=”Seattle”
When you generate mappings from a mapping template, PowerCenter assigns the following suffixes to the groups:
Group
Suffix
Examples
DEFAULT
1
OutputPortA1
OutputPortB1
OutputPortC1
LONDON_GROUP
2
OutputPortA2
OutputPortB2
OutputPortC2
SEATTLE_GROUP
3
OutputPortA3
OutputPortB3
OutputPortC3
When you create the rules for the links that start from a Router transformation, identify the group associated with the link. The rules must refer to port names with the suffix for the associated group.
If you create rules that refer to port names with the suffix for another group, you cannot generate mappings from the mapping template.

0 COMMENTS

We’d like to hear from you!