what is materialised view? why we use it in data warehousing?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / suman palisetty
Materialized Views are objects which have information that has been aggregated and summarized from source tables.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Answer / ram
Materialised view will stores the results of sql in the tables form in the database. materialised view contains data physically.view doesn't contain data physically.materialised view will be updated with batch upted know as refreshes.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / manoj
Materialized view contains special cache to store the data
and structure of the table.
it improves the perrformance becuase when we write the
query every time data is not feched from the base table
i.e. we will use in Datawarehouse.
Is This Answer Correct ? | 0 Yes | 2 No |
how to connect datamarts
------Diff B/W DrillThrough and master and Detailed Report?
what is report view?
I have two date promts which optional. by defalt it will be checked.i want to unchek that date prompts.How to uncheck the date prompts in cognos
what is stitch query in reportnet?
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
What are the types of studio?
what is the generated prompt,how can i use?
Any Cognos planning Queries Rise
What are the Macros?
Wht is difference between content store and content manager?
2 Answers Satyam, Tech Mahindra,
What is IQD?What is contained in IQD?