English
  • PowerCenter 10.4.0
  • All Products

Table of Contents

Search

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

Release Guide

Release Guide

Back Next

Pushdown Optimization for PostgreSQL

Pushdown Optimization for PostgreSQL

Effective in version 10.2 HotFix 2, when the connection type is ODBC, you can select the ODBC subtype as
PostgreSQL
 to push transformation logic to PostgreSQL. You can configure source-side or full pushdown optimization to push the transformation logic to PostgreSQL.
For more information about the supported functions and transformations that you can push to the PostgreSQL database, see the
Informatica PowerCenter 10.2 HotFix 2 Advanced Workflow Guide
.