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
Explain the types of lookup transformation?
What are the transformations that are not supported in mapplet?
Is it possible to create multiple domains on a single Informatica server?
What are the tasks that can be performed using sq?
What is target load order?
What are the different options available for update strategy?
What are pre and post-session shell commands?
What is Data Caches size?
Can we create a Integration service without a Repository service and vice versa?
How to generate sequence numbers using expression transformation?
What is a joiner transformation?
Performance tuning( what you did in performance tuning)
What is the need for an etl tool?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs