what is materialised view? why we use it in data warehousing?
Answer Posted / manoj
Materialized view contains special cache to store the data
and structure of the table.
it improves the perrformance becuase when we write the
query every time data is not feched from the base table
i.e. we will use in Datawarehouse.
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is the size of database for you project?
Define metrics studio?
What are the methods by which it non-durable model could be changed into the durable model?
How do you Parametermap variables in Quiries?
hi friends pls forward impropmtu interview question
What is the metric store database?
What do you understand by the term 'dynamic cube'?
---------------Tell me about DWH Concepts?
how to merge 2 crosstabs thans
What is a dimension?
Explain informatica architecture?
what is the procedure for scheduling conditional rendering?
How can I schedule reports in cognos?
What is called Cognos powerplay?
what is hints in cognos and where we use it.