Interested to Buy Any Domain ? << Click Here >> for more details...
what is materialised view? why we use it in data warehousing?
- 5 Answers
- 10658 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
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
what are the filters in framework manager and report studio?
difference between impromptu and cognos8
What is called a slice?
Tell me about Dnamic and Static Dashboards?
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.
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
how to explain health care project and which reports we can create in health care doain?
How to do Performence Tunning in Cognos Reports?
What are all the types of gateway used in Cognos?
How is cognos model organization works?
What is the model filter?
How do we convert from Numeric to be Words?
What is Bitmap Index?
What is defined as Query studio?
