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 difference between drill through, drill across?
What are the advantages of cognos?
How can we Maintain the Cube Security by Category level and Dimension level ?
Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance
Can you define report item?
What are the services provided in cognos 8?
What are the different types of reports present in cognos?
How create measures and dimensions?
How to generate cubes in cognos?
What are initial page components of Cognos connection?
What do you understand by the term 'dynamic cube'?
faq's on cognos
How can we create a dynamic column name in cognos?
What are the considerations regarding performance kept in mind while setting up cognos?
What are all the components of Report Studio?