Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between view and materialised view?
- 6 Answers
- 14620 Views
- I also Faced
- E-Mail Answers
Answer Posted / anurag arun edlabadkar
Difference Between Inline View & Materialized View?
You can use Materialized views to pre-aggregate the data
and improve the query performance. When you create a
materialized view, Oracle created a physical table to hold
data that would usually be read via a view. When you create
a materialized view, you specify the view's base query as
well as a schedule for the refreshes of its data. You can
then index the materialized view to enhance the performance
of queries against it. As a result, you can provide data to
your user in the format they need, indexed appropriately.
A View is a database object that is a logical
Representation of of a table. It is derived from a table
but has no storage of its own and often may be used in the
same manner as a table.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is an active transformation?
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.
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Different sorts of metadata that stores in the storage facility?
What are the differences between oltp and olap?
How can you define user defied event?
How to do the error handling of if ur source is flatfiles?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is a stored procedure transformation?
Make a note of the quantity vaults made in informatica?
What if the source is a flat-file?
Explain pmcmd command usage in informatica
How big was your fact table
What is the difference between stop and abort in informatica
