
PowerCenter ? Partial Pushdown Optimization
Posted by: Informatica Enterprise Data Integration
Informatica PowerCenter mapping example to demonstrate the Pushdown optimization feature to push down the transformations partially to the database.
Overview
When you configure pushdown optimization, the Integration Service tries to push each transformation to the database. The following criteria affects whether the Integration Service can push the transformation to the database:
- Type of transformation.
- Location of the transformation in the mapping.
- Mapping and session configuration for the transformation.
- The expressions contained in the transformation.
Features
- PowerCenter version 9.1 and 9.5