The update strategy expression uses the IIF or DECODE function from the transformation language to test each row.

For example, the following IIF statement flags a row for reject if the entry date is after the apply date. Otherwise, the statement flags the row for update:

IIF( ( ENTRY_DATE > APPLY_DATE), DD_REJECT, DD_UPDATE)

You can configure parameters in an update strategy expression. Create parameters or browse parameters in the Expression Editor.

If the transformation is in a dynamic mapping, the generated fields in the transformation might change. You can parameterize the complete update strategy expression. If you use a parameter to define the expression, the Developer tool cannot validate the expression. An expression parameter cannot contain another parameter.