Mapping Analyst for Excel Guide

10.5
- 10.5.7
- 10.5.6
- 10.4.0

Back Next

Rule Example

A rule is a conditional statement that takes input parameters, performs a calculation on the parameters, and produces output parameters.

For example, you create a rule named FullName. The rule uses fname and lname as input parameters, concatenates the parameters, and assigns the result to an output parameter named FullName.

The following table shows the required columns that you configure on the Rules worksheet:

Rule Name	Parameter1 Name	Parameter2 Name	Result1 Name	Expression
FullName	fname	lname	FullName	(fname + " " + lname)

On the Mappings worksheet, include the rule name as an expression to connect source columns first_name and last_name to the target column full_name. Enter the rule name using the following format:

%FullName%

When the PowerCenter Repository Service imports the mapping specification, it creates a Java transformation named FullName. The transformation uses fname and lname as input ports and uses FullName as an output port. The transformation contains the following Java code:

if(true) {
    FullName=fname + " " + lname;
}

Rename Saved Search

Table of Contents

Mapping Analyst for Excel Guide

Mapping Analyst for Excel Guide

Rule Example

Rule Example