Mapping Architect for Visio Guide

10.5.7
- 10.5.6
- 10.5
- 10.4.0

Back Next

Joiner Transformation

Use the Joiner transformation to join data from two sources. One source is the master pipeline. The other is the detail pipeline. In Mapping Architect for Visio, two links connect to a Joiner transformation.

Use the following guidelines when you create links to the Joiner transformation:

The rules for the links to the Joiner transformation must have unique names. If you assign duplicate names to the rules, mapping generation fails in the Designer.

The links to the Joiner transformation must end in ports with unique names. When you create the links to the Joiner transformation, verify that the ending ports do not have duplicate names.

For example, two sources have the same port names that you want to link to a Joiner transformation. If both the master and detail links use the All Ports rule, the ending ports will have duplicate names, as shown in the following situation:

The master link contains starting port names A, B, and C and the link uses the All Ports rule. Therefore, the starting ports link to ending port names A, B, and C.

The detail link contains starting port names A, B, and E and the link uses the All Ports rule. Therefore, the starting ports link to ending port names A, B, and E.

The input ports in the Joiner transformation have the port names A, B, C, A, B, E. Ports A and B are duplicate port names and are therefore invalid.

If the master and detail links contain the same starting ports, use the Named Port, Pattern, or Dictionary rules to ensure that ending ports will contain unique port names. Avoid using All Ports, Primary Key, Foreign Key, and Datatype rules which link starting ports to ending ports with the same name.

The following table describes the required properties for the Joiner transformation:

Transformation Property	Description
Transformation Name	Name of the transformation.
Cache Directory	Specifies the directory used to cache master or detail rows and the index to these rows. By default, the cache files are created in a directory specified by the process variable $PMCacheDir. If you override the directory, make sure the directory exists and contains enough disk space for the cache files. The directory can be a mapped or mounted drive.

The following table describes the Pattern rule that you can use to ensure that there are no duplicate port names in the Joiner transformation:

Link	Pattern	Port Names
Master Link	Starting port pattern: [A-Za-z_][A-Za-z_0-9]* Ending port pattern: $0_1	Starting ports A links to ending port A1. Starting ports B links to ending port B1. Starting ports C links to ending port C1.
Detail Link	Starting port pattern: [A-Za-z_][A-Za-z_0-9]* Ending port pattern: $0_2	Starting ports A links to ending port A2. Starting ports B links to ending port B2. Starting ports C links to ending port C2.

Rename Saved Search

Table of Contents

Mapping Architect for Visio Guide

Mapping Architect for Visio Guide

Joiner Transformation

Joiner Transformation