Table of Contents

Search

  1. Preface
  2. Part 1: Version 10.4.1
  3. Part 2: Version 10.4.0
  4. Part 3: Version 10.2.2
  5. Part 4: Version 10.2.1
  6. Part 5: Version 10.2
  7. Part 6: Version 10.1.1
  8. Part 7: Version 10.1

Write Transformation

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 November 24, 2020