Performance Through Pushdown Processing in Informatica 8.6

4316 Words Jul 30th, 2011 18 Pages
WHITE PAPER

How to Obtain Flexible, Cost-effective Scalability and Performance through Pushdown Processing
Under the Hood of the Pushdown Optimization Option Now Available Through Informatica PowerCenter 8

This document contains Confidential, Proprietary and Trade Secret Information (“Confidential Information”) of Informatica Corporation and may not be copied, distributed, duplicated, or otherwise reproduced in any manner without the prior written consent of Informatica. While every attempt has been made to ensure that the information in this document is accurate and complete, some typographical errors or technical inaccuracies may exist. Informatica does not accept responsibility for any kind of loss resulting from the use of
…show more content…
Driven by accelerated productivity gains and ever-increasing performance, “state of the art” data integration platforms, such as Informatica® PowerCenter®, handle the vast majority of today’s scenarios quite effectively. PowerCenter has enjoyed wide acceptance and use by high-volume customers representing companies and government organizations of all sizes. Based on this use, Informatica has identified performance scenarios where processing data in a source or target database—instead of within the data integration server—can lead to significant performance gains. These scenarios are primarily where data is “co-located” within a common database instance, such as when staging and production reside in a single Oracle relational database management system (RDBMS) or where a large investment has been made in database hardware and software that can provide additional processing power. With these scenarios in mind, Informatica Corporation set out to deliver a solution that delivers the best of both worlds without incurring undo configuration and management burden; a solution that best leverages the performance capabilities of its data integration server and/or the processing power of a relational database interchangeably to
Open Document