Table of Contents

Search

  1. Preface
  2. Data integration tasks
  3. Mapping tasks
  4. Dynamic mapping tasks
  5. Synchronization tasks
  6. Data transfer tasks
  7. Replication tasks
  8. Masking tasks
  9. Masking rules
  10. PowerCenter tasks

Tasks

Tasks

Schema change handling

Schema change handling

Dynamic mapping tasks automatically use dynamic schema change handling. This means that
Data Integration
refreshes the schema of applicable source, target, and lookup objects every time you run the task.
A schema change includes one or more of the following changes:
  • Fields are added.
  • Fields are deleted.
  • Fields are renamed.
  • Field data type, precision, or scale is updated.
Data Integration
updates the schema for data objects with connectors which support dynamic schema handling. A connector that supports dynamic schema handling in mapping tasks supports this functionality in dynamic mapping tasks. You can configure the applicable dynamic schema handling options similar to in a mapping task. To see if a connector supports dynamic schema change handling, see the help for the appropriate connector.
Data Integration
does not update the schema for hierarchical data objects.
If you update fields in the source object, be sure to update the Target transformation field mapping.
Data Integration
writes Null to the target fields that were previously mapped to the renamed or deleted source fields.

0 COMMENTS

We’d like to hear from you!