Table of Contents


  1. Version 10.0
  2. Version 9.6.1
  3. Version 9.6.0

Support for Teradata Array Insert

Effective in version 9.6.1 HotFix 2, when you use an ODBC connection to connect to a Teradata target, you can insert arrays of data into the Teradata target instead of inserting data row by row. Inserting arrays of data results in higher session performance.
To insert arrays of data into a Teradata target by using an ODBC connection, configure the OptimizeTeradataWrite custom property at the session level or at the PowerCenter Integration Service level and set its value to 1.
For more information, see the
Informatica PowerCenter 9.6.1 HotFix 2 Workflow Basics Guide