Interested to Buy Any Domain ? << Click Here >> for more details...
What is 'PowerCenter Pushdown Optimization Option' in
INFORMATICA ?
- 5 Answers
- 19274 Views
- I also Faced
- E-Mail Answers
Answer Posted / chanti
Genrally, data base opertions are more faster than
operations that are excuted under power center.
The main idea behind pushdown optmization is to push some
of the transformation logic to either source side or target
side data base, so that performance can be improved.
| Is This Answer Correct ? | 42 Yes | 1 No |
Post New Answer View All Answers
Explain the types of lookup transformation?
What are the different types of repositories created using informatica?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Explain the difference between mapping parameter and mapping variable?
what are the Methods For Creating Reusable Transformations?
What is workflow manager?
How we can create indexes after completing the load process?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the various types of transformation?
Explain direct and indirect flat file loading (source file type) - informatica
How can we update a record in the target table without using update strategy?
What is meant by active and passive transformation?
r u done any partitions in ur project?
Mention a few design and development best practices for informatica?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
