What is 'PowerCenter Pushdown Optimization Option' in
INFORMATICA ?
- 5 Answers
- 17474 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / chanti
Genrally, data base opertions are more faster than
operations that are excuted under power center.
The main idea behind pushdown optmization is to push some
of the transformation logic to either source side or target
side data base, so that performance can be improved.
| Is This Answer Correct ? | 42 Yes | 1 No |
Answer / 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 |
Answer / rekha
IN GENERAL DATABASE OPERATONS ARE MORE FASTER THAT
EXEXUTING IN THE POWERCENTER,SO WE CAN MOVE THE COMPLEX
TRANSFORMATION LOGIC TO DATABASE FOR PERFORMNACE IMPROVE
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / shiva
understanding the transfromatin language,and analize the
tranfromation language time being taken to achieve the
taske ,then push the trasnformtin logic either source
database or targer database.
| Is This Answer Correct ? | 3 Yes | 0 No |
what is the significance of newlookup port in dynamic look up
What is the functionality of update strategy?
How do we call shell scripts from informatica?
What are the session parameters?
Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.
What is target update override
WHat all joins are there in Source Qualifier?
Explain what are the different versions of informatica?
What is the default join that source qualifier provides?
What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Separate from a database, an information bazaar, and an information stockroom?
Teradata 
