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
Name the different lookup cache(s)?
What do you mean by filter transformation?
What are the new features of informatica 9.x at the developer level?
Explain the features of connected and unconnected lookup.
State the limitations where we cannot use joiner in the mapping pipeline?
Could you explain what is enterprise data warehouse?
Define filter transformation?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Enterprise data warehouse your projects phase by phase explain?
Explain sessions and how many types of sessions are there?
What is a stored procedure transformation?
What is the Process to creating lookup transformation in informatica
What is a mapplet/worklet in informatica?
In informatica workflow manager, how many repositories can be created?