where actually the usage of push down optimization
happens...
Answer Posted / pradeep
Basically we use the push down optimization to reduce the load on the integration service.The integration service translate the business logic into sql query and it pushes to source & Target dbs.In this form we can reduce the load on integration.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How are indexes created after completing the load process?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Differentiate between reusable transformation and mapplet.
update strategy transformation in informatica
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Explain direct and indirect flat file loading (source file type) - informatica
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Mention few advantages of router transformation over filter transformation.
Differentiate between Load Manager and DTM?
what is SDLC way of code development?
Explain what are the different versions of informatica?
Explain incremental aggregation in informatica
What is the difference between Active and Passive transformation?
How can informatica be used for an organization?
What is the meaning of up gradation of repository?