Interested to Buy Any Domain ? << Click Here >> for more details...
what is work of PUSH DOWN option
- 2 Answers
- 7500 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 you can differentiate between connected lookup and unconnected lookup?
Difference between STOP & ABORT in Informatica.
3 Answers Accenture, Wells Fargo,
What is an aggregator transformation?
What are events in workflow manager?
What is a surrogate key?
What is decode in informatica?
how to connect two or more table with single source qualifier?
what are surrogate keys?
What are the mapings that we use for slowly changing dimension table?
Briefly explain the aggregator transformation?
When will you use SQL override in a lookup transformation?
Enlist the differences between database and data warehouse.
Teradata 
