Define an expression parameter in the Expression Editor. Select

Specify by Parameter

to indicate that the complete expression is parameterized.

The following image shows the

Specify by Parameter

option for the filter condition:

When you use an expression parameter, you can create the expression parameter or you can select an existing expression parameter to use in the transformation. An expression parameter can contain ports, operators, and constants. It cannot contain other parameters.

For example, in a Filter transformation you might create a filter expression parameter with the following default value:

EmployeeID > 100

. In the mapping, you might create a different expression parameter with the following default value:

Dept < 2000

. If you bind the mapping parameter to the transformation parameter, you can override the mapping expression parameter at run time. You might create expression parameters with different port names and operators for dynamic mappings.