Data Integration-Free and PayGo
- Data Integration-Free and PayGo
- All Products
Schema handling option
| Target type
| Description
|
---|---|---|
Keep Existing File Format
| File
| Data Integration fetches the most recent target schema at runtime and does not apply upstream schema changes to the target file.
|
Drop Current and Recreate
| Database and file
| For database targets,
Data Integration drops the existing target table and creates a new target table with the schema from the upstream transformations on every run.
For file targets,
Data Integration updates the target schema to match the incoming schema on every task run.
|
Alter and Apply Changes
| Database
| Data Integration updates the target schema with additive changes to match the schema from the upstream transformations. It does not delete columns from the target.
|
Don't Apply DDL Changes
| Database
| Data Integration fetches the target schema at runtime and does not apply upstream schema changes to the target table.
|