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
- 17353 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 EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
design of staging area?
write a query to retrieve the latest records from the table sorted by version(scd)
What are the advantages of informatica?
What is workflow? What are the components of workflow manager?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Can informatica load heterogeneous targets from heterogeneous sources?
What are the settings that you use to configure the joiner transformation?
How many dimensions are there in informatica?
what is SDLC way of code development?
differences between service based and product based?
How can repository reports be accessed without sql or other transformations?
What is olap (on-line analytical processing?
What does reusable transformation mean?
