Interested to Buy Any Domain ? << Click Here >> for more details...
What is 'PowerCenter Pushdown Optimization Option' in
INFORMATICA ?
- 5 Answers
- 19294 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 |
why union transformation is active transformation?
differences between service based and product based?
What is target load order?
if i am having 10 records in source, i want 20 records in target...how will you do it
Why update strategy and union transformations are active?
How to generate sequence numbers using expression transformation?
is it possible to index the data in cache of lkp transformation ?
I have source like this 1:2;3. so i want to load the target as 123
What is InformaticaPowerCenter?
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?
Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)
How many repositories can be created in informatica?
Teradata 
