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 are batches?
How to start a workflow using pmcmd command?
What are some examples of informatica etl programs?
have u done any performance tuning? how u ll do?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What are the data movement modes in informatica?
How is union transformation utilized?
What are active and passive transformations?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How do you use reject loader.
Describe data concatenation?
What is the difference between STOP and ABORT options in Workflow Monitor?
What is the difference between a connected look up and unconnected lookup?
Informatica Checkpoints
What is pmcmd command?