what is materialised view? why we use it in data warehousing?

Answer Posted / ram

Materialised view will stores the results of sql in the tables form in the database. materialised view contains data physically.view doesn't contain data physically.materialised view will be updated with batch upted know as refreshes.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference between list report and crosstab report?

922


What are types of batch available in cognos?

723


hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file

2125


What is a Transformer?

832


Can you explain model durability?

809






Why is auto-regression used in forecasting used on cognos platform?

710


Tell me about Dnamic and Static Dashboards?

2040


how to explain health care project and which reports we can create in health care doain?

6560


Explain what is the main advantage of impromptu over cognos reportnet?

781


What is the difference between Open Connection command ang Open Session Command?

2104


How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?

2332


my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?

1803


Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com

1815


What are products of cognos?

757


What is dtm?

908