Mapping Architect for Visio Guide

10.4.0
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5

Back Next

Parameter

The Parameter rule replaces the rules on a link with the rules included in the parameter you specify. When you create a Parameter rule, select the name of a parameter from the list of mapping template parameters.

The value of the parameter must be a set of rules that you want to use for the link.

The following figure shows how to configure rules with the same syntax on the Link Rules window:

The Link Rules window has a Rule Set Name field at the top of the window. The field is set to RuleSetName. The rules are All Ports;Named:$COL_NAME$(TO) $COL_NAME$_IN;DataType:date/time

The rules must be separated by semicolons (;).

Use a Parameter rule when the rules for a link between two transformation objects change from mapping to mapping. For example, you can create a parameter named $REPLICATION_RULES$ and provide the following value in the parameter file:

<PARAM NAME="$REPLICATION_RULES$" 

VALUE="Primary Key;Named:$COL1$ (TO) $COL2$;DataType:date/time" />

Mapping Architect for Visio expands the Parameter rule to separate rules and evaluates the rules in the order they are listed.

You can provide different parameter values for the $REPLICATION_RULES$ for each mapping you create from the mapping template.

Limitations

You cannot include the following types of rules in a Parameter rule:

Parameter rule.
You cannot include a Parameter rule within a Parameter rule.

Rules with associated groups.
You cannot include rules for links that connect to multi-group transformations such as a Router transformation. For example, you cannot include the following rule in a Parameter rule:

{GROUPA}Named:ITEM_DESC (TO) DESCRIPTION

Exclusion rule.
You cannot include a rule with the exclude option enabled. For example, you cannot include the following rule in a Parameter rule:

EXLUDE Foreign Key

Rename Saved Search

Table of Contents

Mapping Architect for Visio Guide

Mapping Architect for Visio Guide

Parameter

Parameter

Limitations