Performance Through Pushdown Processing in Informatica 8.6

Only available on StudyMode
  • Download(s) : 72
  • Published : August 14, 2011
Open Document
Text Preview
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 information contained in this document. The information contained in this document is subject to change without notice. The incorporation of the product attributes discussed in these materials into any release or upgrade of any Informatica software product—as well as the timing of any such release or upgrade—is at the sole discretion of Informatica. Protected by one or more of the following U.S. Patents: 6,032,158; 5,794,246; 6,014,670; 6,339,775; 6,044,374; 6,208,990; 6,208,990; 6,850,947; 6,895,471; or by the following pending U.S. Patents: 09/644,280; 10/966,046; 10/727,700. This edition published April 2006

White Paper

Table of Contents
Executive Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2 Historical Approaches to Data Integration . . . . . . . . . . . . . . . . . . . . . . . . .4 The Combined Engine- and RDBMS-based Approach to Data Integration . .5 How Pushdown Optimization Works . . . . . . . . . . . . . . . . . . . . . . . . . . . . .5

Overview of Pushdown Processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .6 Two-Pass Pushdown Processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .7 Partial Pushdown Processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .8 Full Pushdown Processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .8 Platform-specific Pushdown Optimization . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .9 Limitations on the Types of Transformations that Can Be Pushed to the Database . . . . . .9

Benefits of Pushdown Optimization . . . . . . . . . . . . . . . . . . . . . . . . . . . . .10 Increased Performance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .10 Increased IT Team Productivity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .11 Reduced Risk and Enhanced Flexibility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .12

Conclusion and Next Steps . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .12

Pushdown Optimization

1

Executive Summary
Over the next five to 10 years and beyond, the two dominant variables in the enterprise data integration equation are painfully clear—more data and less time. Given these, what’s the right data integration strategy to effectively manage terabytes or even hundreds of terabytes of data with enough flexibility and adaptability to cope with future growth? Historically, data integration was performed by developing hand-coded programs that extract data from source systems, apply business/transformation logic and then populate the appropriate downstream system, be it a staging area, data warehouse or other application interface. “Helping to overcome the challenges of implementing data integration as an enterprise-wide function, PowerCenter 8 offers key new features that can enable near-universal data access, deliver greater performance and scalability, and significantly increase developer productivity. The push-down logic will allow us to take further...
tracking img