You can choose how Data Integration handles changes that you make to the data object schemas. To refresh the schema every time the mapping task runs, you can enable dynamic schema handling in the task.
When you use Apache Iceberg tables as the Open Table format, you can configure dynamic schema handling.
The schema change includes the newly added fields within the data object.
You can configure schema change handling on the Runtime Options page when you configure the task.
The following table describes the schema change handling options:
Option
Description
Asynchronous
Default. Data Integration refreshes the schema when you edit the mapping or mapping task, and when Informatica Intelligent Cloud Services is upgraded.
Dynamic
Data Integration refreshes the schema every time the task runs.
You can choose from the following options to refresh the schema:
- Alter and Apply Changes.Data Integration adds new fields from the source schema to the target schema.
- Don't apply DDL Changes.Data Integration does not apply the schema changes to the target.
For more information, see the "Schema change handling" topic in Tasks in the Data Integration help.
Rules and guidelines for dynamic schema handling
Consider the following rules and guidelines when you enable dynamic schema change handling:
•When you use Apache Iceberg Open Table format and create a target table at runtime in a mapping, ensure that the table name and database name contain only lowercase characters.