Table of Contents

Search

  1. Preface
  2. Part 1: Version 10.2
  3. Part 2: Version 10.1.1
  4. Part 3: Version 10.1
  5. Part 4: Version 10.0
  6. Part 5: Version 9.6.1
  7. Part 6: Version 9.6.0

Optimization Methods

Optimization Methods

Effective in version 10.0, Informatica has the following new features for optimization methods:
Global predicate optimization method
The Data Integration Service can apply the global predicate optimization method. When the Data Integration Service applies the global predicate optimization method, it splits, moves, removes, or simplifies the filters in a mapping. The Data Integration Service filters data as close to the source as possible in the pipeline. It also infers the predicate expressions that a mapping generates.
For more information, see the "Mapping Optimization" chapter in the
Informatica 10.0 Performance Tuning Guide
.
Pushdown optimization method
You must select a pushdown type to push transformation logic to the source database. You can choose to push down none of the transformation logic, partial transformation logic, or full transformation logic to the source database. You can also view the mapping optimization plan for the pushdown type.
If the mapping has an Update Strategy transformation, you must determine pushdown compatibility for the mapping before you configure pushdown optimization.
For more information, see the "Pushdown Optimization" chapter in the
Informatica 10.0 Developer Mapping Guide
.
Dataship-join optimization method
If a mapping requires data in two different sized tables in different databases to be joined, the Data Integration Service can apply the dataship-join optimization method.
For more information, see the "Mapping Optimization" chapter in the
Informatica 10.0 Performance Tuning Guide
.
Mapping Optimization Plan
You can view how optimization methods affect mapping performance in a mapping optimization plan.
For more information, see the "Mapping Optimization" chapter in the
Informatica 10.0 Performance Tuning Guide
.


Updated September 25, 2020