Interested to Buy Any Domain ? << Click Here >> for more details...
What is 'PowerCenter Pushdown Optimization Option' in
INFORMATICA ?
- 5 Answers
- 19320 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
How to load time dimension?
what are the unix commands to start the wrk flow ?
can we use union transformation in joiner transformation?how?
1 Answers Dabur, Tech Mahindra,
What are the differences between a connected lookup and unconnected lookup?
What are the new features in Informatica 5.0?
In joiner, how to load Master table in Target?
In target table how to display the system time
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
How do you migrate data from one environment to another?
source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ
In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?
Teradata 
