Interested to Buy Any Domain ? << Click Here >> for more details...
What is 'PowerCenter Pushdown Optimization Option' in
INFORMATICA ?
- 5 Answers
- 19510 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 |
Which is costliest transformation? costly means occupying more memory?
Explain about HLD and LLD ?
what r the values tht r passed between informatics server and stored procedure?
Different circumstance which drives informatica server to expel records?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?
How can you validate all mappings in the repository simultaneously?
how many repositories can v create in informatica .
3 Answers Cap Gemini, Tech Mahindra,
What are the different types of transformation available in informatica.
List the transformation in informatica.
Can anyone briefly describe abt audit table loading?
Teradata 
