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
- 16561 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / manojkumar
Thanks you so much parikhita.
Can you give me the exact two options(use view,..) which
will enabled when we select pod and how these options will
work?
When I select pod on source side, what about target insert
or update query ? will it be pushed to target db? Or only
select query will be pushed to source db ?
and when do we need to go for pushdown optimization
technique ? ofcourse it increses the performance. But at
what situation or circumstances we need to go for pod ?
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Design a mapping to load a target table with the following values from the above source?
What are the designer tools for creating transformations?
What is the session task and command task?
Define joiner transformation?
What all join we can perform in LOOKUP transformation?
explain one complex mapping with logic? sales project?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is the difference between router and filter?
What are the limitations of joiner transformation?
What are the different types of transformation available in informatica.
Explain sessions. Explain how batches are used to combine executions?
EXL informatica Questions
What are the restrictions of union transformation?
Is there any target staging area in informatica not staging area
How to configure mapping in informatica?
