Interested to Buy Any Domain ? << Click Here >> for more details...
what is materialised view? why we use it in data warehousing?
- 5 Answers
- 10305 Views
- HCL, I also Faced
- E-Mail Answers
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 |
Sales person are there in one company How to do Bursting on this particular requirement?
How to schedule the report in Cognos? And i have 2 users u1,u2. how to schedule the report for these 2 users(the 2 users will get result once for a week) but u1 get the result on every monday to his inbox,and u2 get the result on every wednesday to his inbox.
How to findout YEAR CALCULATION? THAT MEANS YOU SHOW THIS YEAR REVENUE AND LAST YEAR REVENUE. WHEN YOU FILTER THIS YEAR VALUE THE RESULT SHOULD DISPLAY THIS YEAR RESULT AND LAST YEAR RESULT.
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt
How you will do the estimation for a task?
How to create a Ratio in Cognos Report studio Reports?
Give me any example of semi and non additive measures?
what use of surgate key in project
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?
Hi, How the relations will be exists in DMR models if u have any idea please explain me
How can I schedule reports in cognos?
------------What is Slicer memberset?
Teradata 
