Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - What is 'Power Center Pushdown Optimization Option' in INFORMATICA ?

asked marvit September 20, 2014 08:05 AM  

What is 'Power Center Pushdown Optimization Option' in INFORMATICA ?


1 Answers

answered By Mswami   0  
Informatica Pushdown Optimization Option increases performance by providing the flexibility to push transformation processing to the most appropriate processing resource. Using Pushdown Optimization, data transformation logic can be pushed to source database or target database or through the PowerCenter server.  This gives the option for the ETL architect to choose the best of the available resources for data processing.

Pushdown Optimization Option enables data transformation processing, to be pushed down into any relational database to make the best use of database processing power. It converts the transformation logic into SQL statements, which can directly execute on database. This minimizes the need of moving data between servers and utilizes the power of database engine.
   add comment

Your answer

Join with account you already have



 Write A Tutorials
Online-Classroom Classes

  1 person following this question

  2 people following this tag

  Question tags

informatica × 1

Asked 2 years and 4 months ago ago
Number of Views -642
Number of Answers -1
Last updated
2 years and 1 month ago ago

  Similar questions

Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!