What is 'PowerCenter Pushdown Optimization Option' in
INFORMATICA ?
Answer Posted / 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 |
Post New Answer View All Answers
Parameter and variable differences
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What are batches?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
How to open an older version of an object in the workspace?
what is SDLC way of code development?
what is size of u r database?
Describe the impact of several join conditions and join order in a joiner transformation?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What are the static cache and dynamic cache in informatica?
Can we change Dynamic to Static or Persistent cache? If so what happens?
How can you differentiate between powercenter and power map?