Answer Posted / kapil
The Pushdown Optimization Option improves performance by
enabling processing to be “pushed down” to a
relational database, maximizing fl exibility, minimizing
unnecessary data movement, and providing the optimal
performance for both data-intensive and process-intensive
transformations.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Which transformation should we use to normalise the COBOL and relational sources?
Global and Local shortcuts. Advantages.
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 are the basic requirements to join two sources in a source qualifier transformation using default join?
What is aggregator transformation in informatica?
What are the static cache and dynamic cache in informatica?
What is Index Caches size?
What are the data movement modes in informatica?
What are the issues you have faced in your project? How did you overcome those issues?
What are the prerequisite tasks to achieve the session partition?
What is the difference between a repository server and a powerhouse?
What is the difference between stop and abort in informatica
What are ETL Tools?
What are the modules in Power Center
What is pmcmd command?