PowerCenter Pushdown Optimization Option

Increasing Performance with Optimal Use of Database Resources

The Pushdown Optimization Option increases systems performance by providing the flexibility to push data transformation processing to the most appropriate processing resource, whether within a source or target database or through the PowerCenter server. With this option, PowerCenter is the only enterprise data integration software on the market that allows you to choose when and how to push down processing, offering a significant performance advantage.

Key Features

• Generates database-specific logic that represents the overall data flow
• Pushes the execution of the logic into the database to perform data transformation processing

Database Neutrality

• Delivers greater scalability and performance by exploiting the processing power of the database in which the data resides
• Automatically leverages database resources
• Ends reliance on database-specific programming to exploit processing power

Single Design Environment with Easy-to-Use GUI

• Decouples data transformation logic from the physical execution plan
• Controls where processing takes place
• Dynamically creates and executes database-specific transformation language

Full Integration Across Entire Data Integration Platform

• Automatically applies pushdown optimization to all data integration processing available on the PowerCenter platform

Benefits

Achieve Flexible, Cost-Effective Scalability and Performance
With this option, PowerCenter is the first data integration platform to offer flexibility in where data processing can occur. In most instances, the PowerCenter data server functions as the “engine” behind data processing. In instances where both source and target data is co-resident in a relational database, processing can be “pushed down” into that database. Pushdown optimization is abstracted from data mapping, which optimizes performance in response to changing runtime demands, peak processing needs, or other dynamic aspects of the production environment.

Enhance Agility and Flexibility of IT Organizations
Even when IT organizations are able to standardize on a single relational database management system, changing business conditions dictate that they need to be prepared to support multiple relational databases. In providing a database-neutral approach, this option offers choice. IT organizations can fully leverage the capabilities of each type of database, and yet stay agile enough to rapidly integrate other types of databases as the need arises.

Increase Productivity of Development Teams
This option eliminates the need to resort to database-specific programming to exploit database processing power. PowerCenter decouples the data transformation logic from the physical execution plan. A single design environment can be used although processing is spread between the data integration and the database engines. By simply selecting pushdown optimization in the PowerCenter GUI, IT organizations can control where processing takes place, and database-specific transformation language is dynamically created and executed as appropriate. And the metadata-driven architecture provides impact analysis and data lineage, ensuring comprehensive visibility into the potential effects of changes.

"With release 8.5 [of PowerCenter], we will be able to upgrade our data integration capabilities and take on even more projects, without sacrificing responsiveness or scalability. For example, [the] pushdown optimization [option] is unique to Informatica, and PowerCenter 8.5 supports additional transformations that can be processed within the database, which will help us maximize existing database resources and improve performance." - Mark Cothron Software Engineering Manager, Ace Hardware read the full story

Product Literature

Pushdown Optimization Option Datasheet
Pushdown Optimization White Paper
PowerCenter Brochure