When you configure the Write transformation to create or replace the target, the Data Integration Service drops any existing target table associated with the write object and creates a table based on the configuration to use the data object or to use the mapping flow.

When the Data Integration Service creates a table based on the data object, the table contains columns that match the ports in the data object. If you create or replace the target at run time with a customized data object, the Data Integration Service creates a table with the name referenced in the data object connection.

When the Data Integration Service creates a table based on the mapping flow, the table contains columns that match generated ports in the Write transformation.

Configure this functionality on the

Advanced

tab of the data object.