Interested to Buy Any Domain ? << Click Here >> for more details...
What is 'PowerCenter Pushdown Optimization Option' in
INFORMATICA ?
- 5 Answers
- 19088 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 rank transform?
How many ways are there to do 'remove duplicate records in informatica'?
What is expression transformation?
if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not
Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static
what are objects in data warehouse?
Can I create one wrkflw which will run different wrkflws on schedule time?
What all are steps in up gradation of Informatica server?
How to start a workflow using pmcmd command?
two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?
What is the difference between sequential batch and concurrent batch and which is recommended and why?
4 yrs etl devloper roles and responsibilities?any body give solutions
Teradata 
