You can add all the Source transformation or transformation ports to the target dynamically when enable a mapping to run dynamically using the
option. You can then use the dynamic ports in the Write transformation.
When you select the
option, the Data Integration Service allows the Target transformation to override ports of the Write transformation with all the updated incoming ports from the pipeline mapping and loads the target table with the ports at runtime.
The Data Integration Service creates the target tables dynamically based on the metadata of the incoming ports from the pipeline mapping.