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
I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series
Explain is there any comparison available for cognos reportnet vs crystal reports?
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
7. What is performance tuning?
What is catalog and types of catalogs in cagonos and which is better?
Can you explain model durability?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
Diff b/w Crossproduct and Outerjoin?
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
5. Which type of report you build more, list, crosstab or chart and why?
Can you define metrics designer?
Define query items?
actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....
Can you define bitmap index?