You can choose to retain an existing target table or create a new target table in the target when you run a dynamic mapping.
You can select one of the following options in the
Target Schema Strategy
advanced properties for the data object write operation:
RETAIN - Retain existing target schema
The Data Integration Service retains the existing target schema.
When you select
option and if the target table does not exist or the metadata of the source and target tables do not match, the mapping fails.
CREATE - Create table at run time
The Data Integration Service creates a new table based on the data object or the mapping flow if the table does not exist in the target.
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. 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.
When you select the
option and if the table already exists in the target location and the source object contains more columns than the existing target table, you must manually delete the existing table from Kudu. After you delete the existing table, you can run the mapping to create the target successfully.
You can assign a parameter to represent the value for the target schema strategy and then change the parameter at run time.