Click

Expression

to open the

Expression Builder

when you perform any of the following tasks:

Create masking rules with Expression masking type.
Add pre-processing or post-processing expressions to a standard masking rule.
Create advanced masking rules.
Assign rules to a column.
Configure expressions in an ad hoc generation rule.
Configure advanced expressions in plans.

The

Expression Builder

shows a list of functions by category. To view the complete list, expand the

All Functions

list.

You can choose from a list of available columns to include in an expression. Select a function and click the

Add

arrow to add the function to an expression. You can choose columns and operators to enter join conditions.

For example, you might create an advanced masking rule that contains a first name and a last name input port. The masking rule has two variable ports that receive masked values for the first name and the last name. You might create an expression for the output port that concatenates the masked names in the variable ports and includes a space between them:

CONCAT( CONCAT( VAR1, ' ' ), VAR2 )

The following image shows the

Expression Builder

where you configure expressions:

For more information about the function syntax, see the

Informatica Transformation Language Reference

.