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 ?
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
What is informatica?
What is standalone command task?
what is the hint? how to use it to reduce the query processing in program?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is difference between a gateway node and worker node?
What do you understand by a term domain?
What is informatica? Why do we need it?
What all are steps in up gradation of Informatica server?
What does “tail –f” command do and what is its use as an Informatica admin.
Whats there in global repository
Enlist the tasks for which source qualifier transformation is used.
Explain the tuning lookup transformation - informatica
Plz can any one say me how to get the informatica certification materials and dumps
draw informatica architecture 8.6 ?
What is InformaticaPowerCenter?