When you select the

Mapping Flow

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.

To enable a dynamic mapping using the

Mapping Flow

option, select the value of the

Columns defined by

property as

Mapping Flow

in the

Ports

tab in the Write transformation.

You must specify a value of the

Target Schema Strategy

data object write operation property when you select the

Mapping Flow

option.