PowerCenter ? Full Pushdown Optimization

PowerCenter ? Full Pushdown Optimization

Posted by: Informatica Enterprise Data Integration

Informatica PowerCenter mapping example to demonstrate the Pushdown optimization feature where expression, joiner, filter, aggregator and sorter transformations are pushed 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
The criteria might also affect the type of pushdown optimization that the Integration Service can perform and the type of database to which the transformation can be pushed. To use full pushdown optimization, the source and target databases must be in the same relational database management system. The download contains a sample mapping to demonstrate full pushdown functionality with expression, joiner, filter, aggregator and sorter transformations.

Features

Support