How we will implement Pushdown Optimization and Types in Informatica with better examples
Answer Posted / sridhar,informatica developer
normally pushdown optimization is used for eliminating
bottlenecks from session and to increase the performance of
your session.
here t he integration service pushing the business logic to
the target or source or both.
pushdown optimization can do in 3 ways
1)source side
2)target side
3)full
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What are the types of caches in lookup?
How to go to the older version for a mapping?
What are batches?
Explain sessions. Explain how batches are used to combine executions?
What are the different transaction levels available in transaction control transformation?
What is the benefit of session partitioning?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
How to differentiate between the active and passive transformations?
What is a sequence generator transformation?
What do you mean by channel change?
what is the difference between informatica6.1 and infomatica7.1
What is a pre-defined event and user-defined event?
What are the differences between a connected lookup and unconnected lookup?
What are roles and groups and benefits of using them?