When you configure a Write transformation, you can choose from the following target schema strategy options for the target data object:

RETAIN - Retain existing target schema. The Data Integration Service retains the existing target schema.
CREATE - Create or replace table at run time. The Data Integration Service drops the target table at run time and replaces it with a table based on a target data object that you identify.
Assign Parameter. Specify the
Target Schema Strategy
options as a parameter value.

Previously, you selected the

Create or Replace Target Tables

advanced property so that the Data Integration Service drops the target table at run time and replaces it with a table based on a target table that you identify. When you do not select the

Create or Replace Target Tables

advanced property, the Data Integration Service retains the existing schema for the target table.

In existing mappings where the

Create or Replace Target Tables

property was enabled, after the upgrade to version 10.2.2, by default, the

Target Schema Strategy

property shows enabled for the

CREATE - Create or replace table at run time

option. In mappings where the

Create or Replace Target Tables

option was not selected, after the upgrade, the

Target Schema Strategy

property is enabled for the

RETAIN - Retain existing target schema

option. After the upgrade, if the correct target schema strategy option is not selected, you must manually select the required option from the

Target Schema Strategy

list, and then run the mapping.

For more information about configuring the target schema strategy, see the "Write Transformation" chapter in the

Informatica Transformation Guide

, or the "Dynamic Mappings" chapter in the

Informatica Developer Mapping Guide

.