You can use a Joiner transformation in a dynamic mapping. You can reference dynamic ports and generated ports in join conditions.
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 Joiner transformation in a dynamic mapping, the structure of the source can change. The input ports and the ports in the join condition change too.
You can perform the following tasks to configure a Joiner transformation in a dynamic mapping:
Define dynamic ports.
Define dynamic ports and generated ports to accommodate the different input columns from a dynamic source. You can include dynamic ports or generated ports in the join condition.
Define port selectors.
Define a port selector that contains the ports to use in the join condition. Configure selection rules that determine the ports to include in the port selector. You can parameterize the port selector to include specific ports at run time.
Parameterize the join condition.
You can parameterize the entire join condition. Configure an expression parameter for each join condition you might need.
For more information about dynamic mappings, see the