For example, a dynamic mapping includes a Joiner transformation with the following Join condition:

CustomerID = CustomerNo

CustomerID is a generated port in the Joiner transformation. Since the mapping has a dynamic source, the mapping can run with several different source file formats. The column that contains the customer number has a different name in each source file:

CustomerID

,

CustomerNum

, or

CustNO

.

You can create a port selector in the Joiner transformation to accommodate the different customer column names from the dynamic source. Configure a port selector with a selection rule that includes any port name with the prefix "Cust."

Then, configure the Join condition to include the port selector name instead of the CustomerID column name:

Customer_PortSelector = CustomerNo

The join condition is valid with any port name that starts with "Cust."

A port selector can have one or more ports in it. The join condition can include multiple ports if the master group and the detail group in the join condition contain the same number of ports.