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.
Configure schema change handling in the Advanced Options section on the Runtime Options tab when you configure the task. You can configure asynchronous or dynamic schema change handling.
When you configure dynamic schema change handling, you can choose from the following options to refresh the schema:
Keep Existing File Format
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
Data Integration updates the target schema to match the incoming schema on every task run.
Restrictions
Consider the following restrictions when you configure dynamic schema handling:
•When you select the Keep Existing File Format option while configuring dynamic schema handling in a mapping that creates a new target at runtime and the target already exists, the changes in the source are propagated to the target.
•You cannot use the Drop Current and Recreate option in mappings in advanced mode.
•When you select the Keep Existing File Format option while configuring dynamic schema handling in a mapping that creates a new target at runtime and the target already exists, the changes in the source are propagated to the target when the object name contains special characters.