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
- 17474 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 Cognos script editor?
How to use pmcmd utility command?
Write the unconnected lookup syntax?
Explain load alternative records / rows into multiple targets - informatica
What is meant by LDAP users?
How can you define user defied event?
How to Create a folder using pmrep command?
What is an Integration service in Informatica?
How are the sources and targets definitions imported in informatica designer?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What are the types of schemas we have in data warehouse.
What is informatica?
What is decode in static cache?
Performance tuning in UNIX for informatica mappings?
what are factless facts? And in which scenario will you use such kinds of fact tables.
