What is 'PowerCenter Pushdown Optimization Option' in
INFORMATICA ?

Answer Posted / sudhar

Pushdown optimization is used to push the complex logic to
the database level. This will reduce the complexity of the
Powercenter mappings and increases the performance.

Is This Answer Correct ?    31 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain transaction control transformation in informatica

1029


What are the transformations that are not supported in mapplet?

786


What are ETL Tools?

852


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1711


How can you generate reports in informatica?

768


What is the need of etl tools?

833


How many ways are there to do 'remove duplicate records in informatica'?

777


Do you find any difficulty while working with flat files as source and target?

876


How to generate or load values in to the target table based on a column value using informatica etl tool.

835


what are the different types of transformation available in informatica. And what are the mostly used ones among them?

727


Differentiate between reusable transformation and mapplet.

849


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1057


Explain how many types of dimensions are available in informatica?

776


How can you differentiate between powercenter and power map?

843


How to load a Dimension ? and how to load a fact table?

1150