Interested to Buy Any Domain ? << Click Here >> for more details...
Whatis the difference between View and Materialized View ?
- 11 Answers
- 56363 Views
- Satyam, Syntel, I also Faced
- E-Mail Answers
Answer Posted / anju
A materialized view is a stored summary containing pre-
computed results.As the data is pre-computed, materialized
views allow for faster query answers
In warehousing applications, large amounts of data are
processed and similar queries are frequently repeated. If
these queries are pre-computed and the results stored in
the data warehouse as a materialized view, using
materialized views significantly improves performance
by providing fast lookups into the set of results.
A Materialized View generally behaves like a Index and it
can also have any Number of Aggregates and Joins.
| Is This Answer Correct ? | 37 Yes | 6 No |
Post New Answer View All Answers
Which transformation is needed while using the Cobol sources as source definitions?
What is informatica powercenter repository?
How to extract sap data using informatica? What is abap? What are idocs?
How many number of sessions can one group in batches?
How can we improve session performance in aggregator transformation?
How many dimensions are there in informatica?
What is the Process to creating lookup transformation in informatica
How to generate sequence numbers?
tell me 5 session failure in real time how can you solve that in your project?
How can you differentiate between powercenter and power map?
what is the hint? how to use it to reduce the query processing in program?
What's the layout of parameter file (what does a parameter file contain?)?
How to differentiate between the active and passive transformations?
What is different between the data warehouse and data mart?
Partition, what happens if the specified key range is shorter and longer
