Hive Connector

Back Next

Dynamic schema handling

When you add a mapping or a mapping configured in advanced mode 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 precision.

Configure schema change handling on the

Runtime Options

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 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 applies the following changes from the source schema to the target schema: New fields: Alters the target schema and adds the new fields from the upstream transformation. Renamed fields: Adds renamed fields as new columns in the target. Precision updates. Applies these changes to the target. Deleted fields: Ignores deleted fields. 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 upstream transformation. Don't apply DDL changes. Data Integration does not apply the schema changes to the target.

Option

Description

Asynchronous

Default.

Data Integration

refreshes the schema when you edit the mapping or 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

applies the following changes from the source schema to the target schema:

New fields: Alters the target schema and adds the new fields from the upstream transformation.

Renamed fields: Adds renamed fields as new columns in the target.

Precision updates. Applies these changes to the target.

Deleted fields: Ignores deleted fields.

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 upstream transformation.

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.

Mappings and mapping tasks with Hive Connector

Rules and guidelines for dynamic schema handling in mappings

Download Guide

Watch

Comments

Cloud Connectivity Homepage