What is 'PowerCenter Pushdown Optimization Option' in
INFORMATICA ?
- 5 Answers
- 18390 Views
- I also Faced
- E-Mail Answers
Answer Posted / sudhar
Pushdown optimization is used to push the complex logic to
the database level. This will reduce the complexity of the
Powercenter mappings and increases the performance.
| Is This Answer Correct ? | 31 Yes | 4 No |
Post New Answer View All Answers
what is mean by complex business rule ?
How to call shell scripts from informatica?
While migrating the data from one environment to another environment how would you manage the connections?
What is an unconnected transformation?
What is the commit type if you have a transaction control transformation in the mapping?
Explain how to import oracle sequence into informatica?
How to improve the performance of a session using sorter transformation?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
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
Is it possible to revert a global repository to local one and why?
differences between service based and product based?
What is a sequence generator transformation?
How might you approve all mappings in the archive all the while?
Briefly define a session task?
In informatica workflow manager, how many repositories can be created?
