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
.
Comments
0 comments
Please sign in to leave a comment.