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
- 17520 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
How an expression transformation differs from aggregator transformation?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What do you mean by enterprise data warehousing?
How can we improve session performance in aggregator transformation?
Differences between connected and unconnected lookup?
what is Active lock explain
What are the different options available for update strategy?
How to join three sources using joiner? Explain though mapping flow.
r u done any partitions in ur project?
What is a rank transform?
What does refresh system mean, and what are its distinctive choice?
What you know about transaction control transformation?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
how to load rows into fact table in data warehouse
