Table of Contents

Search

  1. Version 10.2.2
  2. Version 10.2.1
  3. Version 10.2
  4. Version 10.1.1
  5. Version 10.1

Release Guide

Release Guide

Write Transformation

Effective in version 10.2.2, the Create or Replace Target Tables advanced property in a Write transformation for relational, Netezza, and Teradata data objects is renamed to Target Schema Strategy.
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.


Updated July 25, 2019


Explore Informatica Network