Table of Contents

Search

  1. Preface
  2. Part 1: Introduction to Amazon Redshift connectors
  3. Part 2: Data Integration with Amazon Redshift V2 Connector
  4. Part 3: Data Integration with Amazon Redshift Connector

Amazon Redshift Connectors

Amazon Redshift Connectors

Dynamic schema handling for mappings and elastic mappings

Dynamic schema handling for mappings and elastic mappings

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.
A schema change includes one or more of the following changes to the data object:
  • Fields added.
  • Fields updated for data type, precision, or scale.
Configure schema change handling on the
Schedule
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
    alters the target schema and adds the new fields from the source.
  • Drop Current and Recreate.
    Drops the existing target table and then recreates the target table at runtime using all the incoming metadata fields from the source.
  • 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
.