Create a rule for a target column in a mapping specification to develop business logic for the column. When you create a rule, you configure the edit options for the rule. You can also choose to make the rule reusable.
From the Actions menu, click
Edit
Rules
.
The
Edit Mapping Specification
wizard appears.
Select the
New
icon.
The
New Rule
wizard appears.
Select
Create a Rule
.
Click
Next
.
Enter a name and an optional description.
Select a target column name to apply the rule to.
To make the rule reusable, select
Save the rule
and select a project to save the rule.
On the
Functions
tab, select a function, click the arrow icon, and select a column to add the function to the Expression editor.
Optionally, on the Columns tab. select a target column and click the arrow icon to add it to the Expression editor.
Optionally, on the
Rules
tab, select a column and datatype and click the arrow icon to add the rule column to the Expression editor.
Optionally, on the
Lookup
tab, select a column and datatype and click the arrow icon to add the Lookup column to the Expression editor.