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
- 17360 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
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is the difference between stop and abort in informatica
How to load the data from a flat file into the target where the source flat file name changes daily?
Explain the difference between a data warehouse and a data mart?
Is it possible to revert a global repository to local one and why?
Scheduling properties,whats the default (sequential)
How to start a workflow using pmcmd command?
Quickly characterize reusable change?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is a passive transformation?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Define the various join types of joiner transformation?
What is source qualifier transformation in informatica?
