Mapping Architect for Visio Guide

10.5.6
- 10.5.7
- 10.5
- 10.4.0

Back Next

Step 2. Define Parameter and Rules

Use parameters and rules in the mapping template to define different logic for each mapping. To define parameters, complete the following steps:

Set parameters for the source and target definitions.

Set a parameter in a link rule to specify which data to load into the target.

To set parameters for the source and target definitions, open each mapping object and specify a parameter for the source table and target table.

The following table shows the source table definition properties:

Property	Value
Transformation Name	Employees
Source Table	$Source$
Database Name	FlatFile
Database Type	Flat File

Next, set a parameter for the link rule to specify which source data you want to load to the target. To update the rule, double-click the link between the source qualifier and the target.

The following example shows a link rule between the source qualifier and the target:

Rule Set Name: Rule 1
Named:EMPLOYEE_NUMBER (TO) EMPLOYEE_NUMBER

The link rules that appear are based on the original mapping. Create parameters because the mappings that you plan to generate load different source data into the target.

To create a parameter that specifies the data to load into the target, complete the following steps:

Delete link rules between the source qualifier and the target.

Create a link rule that includes parameters. The following example shows a link rule that includes parameters for the named port:

Starting Port Name: $Source$
Ending Port Name: $Target$

The Named Port link rule contains two parameters, one for the source port ($Source$) and one for the target port ($Target$).

When you define the $start$ and $end$ parameter values, you can enter the source and target port names for each mapping in the Import Mapping Template Wizard.

Rename Saved Search

Table of Contents

Mapping Architect for Visio Guide

Mapping Architect for Visio Guide

Step 2. Define Parameter and Rules

Step 2. Define Parameter and Rules