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 |
im having null data in one of the cell in my report i have to display as "no data" when u run the report how can i achive this problem?
What is a Folder?
Write various indexes used in cognos?
how you migrate reports to cognos 8 from previous versions?
How to convert the tabular report into graphical report?Is this possible in cognos 8 report studio?
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
Hi Friends, Just want to know, day to day is increasing or decreasing Cognos Usage in the Market? New Reporting tools to driving Reporting Market Spotfire, Tableau,Qlick View, some other New Tools. Which Reporting tool can generate Lot of Opportinities in the Market? Please Reply to this, My Advanced Thank to you. Thank You Kumar
what is the use of lock and unlock
i have 4 countries in my database as USA, UK, INDIA, CHANA. In value prompt's prompt control list, i want WESTERN_COUNTRIES, ASIAN_COUNTRIES instead of those country names. When i click on WESTERN_COUNTRIES, it should retrieve USA, UK records and when i click on ASIAN_COUNTRIES, it should retrieve INDIA, CHINA records. How is it possible?
what are burst options you have?
How can we improve performance in report studio level?
Can anyone tell me the step by step process how to connect cognos to oracle?