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
Explain transaction control transformation in informatica
What are the transformations that are not supported in mapplet?
What are ETL Tools?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
How can you generate reports in informatica?
What is the need of etl tools?
How many ways are there to do 'remove duplicate records in informatica'?
Do you find any difficulty while working with flat files as source and target?
How to generate or load values in to the target table based on a column value using informatica etl tool.
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Differentiate between reusable transformation and mapplet.
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.
Explain how many types of dimensions are available in informatica?
How can you differentiate between powercenter and power map?
How to load a Dimension ? and how to load a fact table?