A dynamic mapping is a mapping in which the sources, targets, and transformation logic can change at run time. You can set parameters and rules to change the structure of the data. When you use a Lookup transformation in a dynamic mapping, the input ports of the Lookup transformation might change based on the source data. The structure of the lookup source and the ports in the lookup condition might change.

You can perform the following tasks for a Lookup transformation to use the transformation in a dynamic mapping:

Define dynamic ports

Define dynamic ports and generated ports to accommodate changes to the input columns.

Parameterize the lookup source

Assign a parameter for the data object that defines the lookup source. You can parameterize the lookup source in a nonreusable Lookup transformation.

Define port selectors

Define a port selector that specifies the ports to use in the lookup condition. You can parameterize the port selector ports in a nonreusable Lookup transformation.

Parameterize the lookup condition

Create an expression parameter and define a default value that contains a complete expression.

For more information about dynamic mappings, see the

Informatica Developer Mapping Guide

.