Interested to Buy Any Domain ? << Click Here >> for more details...
When we enable pushdown optimization technique, two options
will be enabled (use view,..). Can anyone tell me how these
two options will work ?
When do we need to go for pushdown optimization technique ?
- 3 Answers
- 17393 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / parikhita prusty
MY dear friend when we used pushdown optimization it
increases the session performanse.
The integration service analyses mapping transformations and
determine which t?r logic to be sent to the target and
source database.
The integration servicetranslates the T/r logic into sql and
sends it into the database for processing.
The pushdown optimization is configured in 3 ways
i) Source side PDO
ii)Target side PDO
iii)Full side PDO(Both source and target side)
If anybody have some doubts u can ask in my mail id
parikhita2000@gmail.com
Regards
Parikhita
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the difference between a repository server and a powerhouse?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What are mapplets?
whats the logic to load the lower level of granularity of data to fact table.
How are the sources and targets definitions imported in informatica designer?
Explain how to import oracle sequence into informatica?
How can informatica be used for an organization?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is pmcmd command?
How to elaborate powercenter integration service?
What is the surrogate key?
How to generate sequence numbers using expression transformation?
What is the difference between source qualifier transformations source filter to filter transformation?
What are the differences between a connected lookup and unconnected lookup?
What is mapping debugger?
