what is materialised view? why we use it in data warehousing?
Answer Posted / c.venkataramana gupta
->Meterialized view is DBA object
-> to create meterializd view need dba perimission(previlege)
->it holds the static data (changes on table will not reflected on view)
-> at time of creating the data is stored in meterialized view, when ever another new record is not restricted.
-> no dml operations allowed
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how to create cubes in transformer ?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
What is the importance of having monitor service in cognos?
Can you explain new content durability?
Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks
What is set to be cardinality?
What is defined as Cognos Impromptu?
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
What is the function of model design accelerator?
What is defined as catalog and types of catalogs in Cognos?
What do you understand by the term 'aggregate cache'?
What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
Which lifecycle we will use for reporting?
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