When you add a mapping to a mapping task, you can choose how Data Integration handles changes in the data object schemas. To refresh the schema every time the task runs, you can enable dynamic schema handling in the task.
A schema change includes one or more of the following changes to the data object:
•Fields added, deleted, or renamed.
•Fields updated for data type, precision, or scale.
Configure schema change handling in the Advanced Options section on the Runtime Options tab 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 Service 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 alters the target schema and adds the new fields from the source.
- Don't apply DDL changes.Data Integration does not apply the schema changes to the target.
- Drop current and recreate.Data Integration drops the existing target table and then recreates the target table at runtime using all the incoming metadata fields from the source.
For more information about dynamic schema handling, see Tasks in the Data Integration documentation.
Rules and guidelines for dynamic schema handling
Consider the following rules and guidelines when you enable dynamic schema change handling in a mapping:
•You cannot make changes to the columns of the Uniqueidentifier data type.
•When you read data from Microsoft Fabric Data Warehouse, any table or column constraints in the source table are not retained in the target.
•When you add a new column to the source data, Data Integration determines the most suitable data type for the target based on the data type of the new source column.
For example, the Uniqueidentifier data type in the source data is mapped to Varchar data type in the target or the Date data type in the source data is mapped to the Datetime2 data type in the target.
•Special characters in the column name are written as underscore in the target.
•When you select the Alter and apply changes option, you cannot refresh schema from a stored procedure. Additionally, Data Integration only adds the new fields from the source and does not rename fields, delete fields, or apply precision and scale updates.
•When you create a new target at runtime and select the Don't apply DDL changes option, schema changes must not be applied. However, Data Integration applies the schema changes to the new target. When you create a new target subsequently and select the Don't apply DDL changes option, the schema changes are not applied to the new target.
•You cannot enable dynamic schema handling to refresh the schema when you parameterize a connection or an object.