You can enable a mapping to run dynamically using the

At runtime, get data object columns from data source

option in the

Data Object

tab of the Read and Write transformations when you create a mapping.

When you add or override the metadata dynamically, you can include all the existing read and write data objects in a single mapping and run the mapping. You do not have to change the source schema to update the data objects and mappings manually to incorporate all the new changes in the mapping.

You can use the mapping template rules to tune the behavior of the execution of such pipeline mapping.

When the Source or Target transformation contains updated ports such as changes in the port names, data types, precision, or scale, the Data Integration Service fetches the updated ports and runs the mapping dynamically. You must ensure that at least one of the column name in the source or target table is the same as before refreshing the schema to run the dynamic mapping successfully.

Even though the original order of the source or target ports in the table changes, the Data Integration Service displays the original order of the ports in the table when you refresh the schemas at runtime.

If there are more columns in the source table as compared to the target table, the Data Integration Service does not map the extra column to the target table and loads null data for all the unmapped columns in the target table.