what is materialised view? why we use it in data warehousing?
- 5 Answers
- 9464 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / gopal
MT views is a table which occupies space when ever we update it doesn't update in parent table we need to write a command to refersh the data in to parent table
Mainly used for Pre-aggregated Calculations....
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are various types of gateways in cognos?
What is the use of report studio?
What is the use of powerhouse?
What you mean by drill across and what is the difference between drill through, drill across?
Can you define drill down and drill up?
What is drill down and slicing and dicing whats the difference between them?
What is model filter?
How can create users and permissions in cognos?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
9. What was the most complex type of report you dealt with?
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
What is the metric store database?
What is the use of cognos decision stream?
Can you define a query subject?
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
