what is work of PUSH DOWN option
Answers were Sorted based on User's Feedback
Answer / satya
In addition to Kapil's answer, You can have "push down"
optimization at source database or target database or Full
(Source and target). But before you enable this option you
keep the following things in mind
1. When you are processing long transaction at database
level , The objects will be lock and data base objects are
not available for other operations for long time.
2. It will inturn hampers the datbase concurrency and
increases the chance of "Dead locks" on database
Thanks : Satya
Is This Answer Correct ? | 5 Yes | 1 No |
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 |
What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.
Why should we use star schema in datawarehouse design?
without table how to come first record only in oracle?
What is the Process to creating lookup transformation in informatica
Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??
What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1
how do u get the first record from 50,000 records ?
10 Answers TCS, UBS,
How can we use mapping variables in informatica?
Why filter transformation is an active one?
Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?
What is a repository manager?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?