What is 'PowerCenter Pushdown Optimization Option' in
INFORMATICA ?
Answer Posted / rekha
IN GENERAL DATABASE OPERATONS ARE MORE FASTER THAT
EXEXUTING IN THE POWERCENTER,SO WE CAN MOVE THE COMPLEX
TRANSFORMATION LOGIC TO DATABASE FOR PERFORMNACE IMPROVE
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Define mapplet?
What does role playing dimension mean?
Explain lookup transformation in informatica
What is sorter transformation?
What are the static cache and dynamic cache in informatica?
Write the unconnected lookup syntax and how to return more than one column.
What is a sequence generator transformation?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How you prepared reports for OLAP?
What is meant by pre and post session shell command?
Why filter transformation is an active one?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is DR strategy for Informatica project?