What is 'PowerCenter Pushdown Optimization Option' in
INFORMATICA ?
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 |
How will the document be delivered to me?
What is a test load?
What is intricate mapping?
Explain pushdown optimization and types in informatica
I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.
What are the types of maping in Getting Started Wizard?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Enlist few areas or real-time situations where informatica is required.
What are roles and groups and benefits of using them?
in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
What is Data Caches size?