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

.

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

.

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

.

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

.