Preface
Introduction to PostgreSQL Connector
- PostgreSQL Connector assets
Connections for PostgreSQL
Mappings and mapping tasks with PostgreSQL Connector
PostgreSQL objects in mapping tasks
Lookup transformation
- Rules and guidelines for uncached lookups
SQL transformation
- Rules and guidelines for SQL transformations
Migrating a mapping
- Use the same object path for the migrated mapping
- Use a different object path for the migrated mapping
  - Migration options
  - Rules and guidelines for migrating a mapping
PostgreSQL SQL ELT optimization
Data type reference

PostgreSQL Connector

Back Next

Rules and guidelines for dynamic schema handling in mappings

Consider the following rules and guidelines when you enable dynamic schema change handling for tasks:

You must use an existing target in the Target transformation to write the data.

You can't rename the column in the target.

When you use an exiting target table to write the data and delete a column from the source table, the deleted column still appears in the target table even though you run the task.

You can't enable the

Alter and Apply changes

option for the task when you change any constraint such as primary key, not null, or unique key in the source schema.

Rename Saved Search

Table of Contents

PostgreSQL Connector

PostgreSQL Connector

Rules and guidelines for dynamic schema handling in mappings

Rules and guidelines for dynamic schema handling in mappings