what is materialised view? why we use it in data warehousing?
- 5 Answers
- 8610 Views
- HCL, I also Faced
- E-Mail Answers
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
Which lifecycle we will use for reporting?
What is the function of model design accelerator?
What is called materialized view?
What is looping and how to avoid it in framework manager?
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
5. Which type of report you build more, list, crosstab or chart and why?
What junk dimension contains?
What is the size of database for you project?
what are the features in cognos8ui
9. What was the most complex type of report you dealt with?
-------------What is Coditional Prompting?
What you mean by drill across?
What are the types of folder present in cognos?
What are query items?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
