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
- 17644 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 happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What are the modules in Power Center
How can we update a record in the target table without using update strategy?
What are the guidelines to be followed while using union transformation?
Why sorter is an active transformation?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How do you migrate data from one environment to another?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What does update strategy mean, and what are the different option of it?
How do you load only null records into target? Explain through mapping flow.
What is the need of etl tools?
What is the command used to run a batch?
Explain the features of connected and unconnected lookup.
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
How to do unit testing in informatica? How to load data in informatica ?
