what is materialised view? why we use it in data warehousing?
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 is the complex report you faced in real time?
hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com
what is catalog and types of catalogs in cagnos and which is better?
How can we Maintain the Cube Security by Category level and Dimension level ?
What is the metric store database?
How the Bursting happens in same report and how to Print the bursting Report?
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
How security is concerned with Reportnet? Explain its implementing steps.
What are slice and dice?
How to create model and how to test model?
What are all the types of gateway used in Cognos?
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
Can you define fan trap?
can we insert all types of charts in a list report? what r the realtime prompts?