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 sq transformation?
Different circumstance which drives informatica server to expel records?
Define update strategy?
Define enterprise data warehousing?
Why update strategy and union transformations are active? Explain with examples.
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
How do you use reject loader.
can anyone explain me about retail domain project in informatica?
How are the sources and targets definitions imported in informatica designer?
What is expression transformation?
What are the tasks that source qualifier perform?
what is Active lock explain
how to load dimension table and fact table. plz tell me the steps.
Differentiate between joiner and lookup transformation?
What is Cognos script editor?