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
How will the document be delivered to me?
Explain the different kinds of facts.
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is informatica etl tool?
generate date / time dimension in informatica
Make a note of the quantity vaults made in informatica?
How union transformation is used?
what is the hint? how to use it to reduce the query processing in program?
What is meant by query override?
Briefly describe lookup transformation?
Whats the difference between informatica powercenter server, repositoryserver and repository?
where to store informatica rejected data?
What is the way to execute pl/sql script using informatica mapping?
Explain the aggregator transformation?
What is fact table? Explain the different kinds of facts.