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 ? | 8 Yes | 0 No |
Post New Answer View All Answers
what is informatica metadata?
How can informatica be used for an organization?
How many transformations can be used in mapplets.
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is data movement mode in Informatica and difference between them?
What is intricate mapping?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Parameter and variable differences
What is informatica worklet?
What are the settings that you use to configure the joiner transformation?
In which transformation you cannot drag ports into it?
What is meant by lookup transformation? Explain the types of lookup transformation?
what are the deliverables?in your project?
can you please explain me pre session and post session options?
Explain pushdown optimization and types in informatica