Interested to Buy Any Domain ? << Click Here >> for more details...
what is work of PUSH DOWN option
- 2 Answers
- 7430 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
How do you load alternate records into different tables through mapping flow?
By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?
What is the filename which you need to configure in UNIX while installing infromatica?
What is the difference between OLTP and ODS?
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?
Explain the difference between mapping parameter and mapping variable?
if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.
How can one identify whether mapping is correct or not without connecting session?
How informatica recognizes mapping?
what is INFORMATICA TESTING process
hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..
What happens if we dont select data driven option?
Teradata 
