Automatically create or alter a destination table

Create table

If you enable parameter Create target table if it doesn't exist. Also update columns to match the target, the Etlworks Integrator will automatically create a destination table if it does not already exist. It uses fields in the source to create and execute CREATE TABLE SQL statements. 

This behavior is enabled by default.

You can find this parameter under Transformation > Mapping > Parameters > Handling schema changes.

Additionally, if the source is a database as well, and the source table has indexes, you can enable the parameter Create Indexes. If it is enabled, the Etlworks Integrator will create the same indexes in the destination that exists in the source.

Alter table 

If you enable parameters Alter target table if the source has columns that the target table doesn't have and Create target table if it doesn't exist. Also update columns to match the target, the system will automatically create and execute ALTER TABLE SQL statement for each column that exists in the source and does not exist in the destination.

This behavior is disabled by default.

You can find this parameter under Transformation > Mapping > Parameters > Handling schema changes.