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
What is mapping debugger?
what is degenerated dimension?
Explain about cumulative Sum or moving sum?
What are the different options available for update strategy?
How does a rank transform differ from aggregator transform functions max and min?
How can we delete duplicate rows from flat files?
Suppose we do not group by on any ports of the aggregator what will be the output?
What if the source is a flat-file?
What are the various types of transformation?
which one is better performance wise joiner or look up
What is the difference between Active and Passive transformation?
how to load dimension table and fact table. plz tell me the steps.
Which is the t/r that builts only single cache memory?
Is stop and abort are same in informatica?
What is meant by lookup transformation?