Interested to Buy Any Domain ? << Click Here >> for more details...
what is Materialized Views?
- 2 Answers
- 7428 Views
- Syntel, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rameshbabu.katikireddy
In literature on data warehousing are created in Oracle using a schema object called a materialized view. Materialized views can be used to perform a number of roles, such as improving query performance or providing replicated data, as described below.
In data warehouses, materialized views can be used to recompute and store aggregated data such as sum of sales. Materialized views in these environments are typically referred to as summaries since they store summarized data. They can also be used to recompute joins with or without aggregations. So a materialized view is used to eliminate overhead associated with expensive joins or aggregations for a large or important class of queries.
Posted by
Rameshbabu.katikireddy
Time:jan.11.2012,6:20pm
Contact09767696346
Karimnagar
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / vr
A materialized view is a database object that contains the results of a query. For example, it may be a local copy of data located remotely, or may be a subset of the rows and/or columns of a table or join result, or may be a summary based on aggregations of a table's data.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to stop a batch?
What is an error log table in informatica occurs and how to maintain it in mapping?
What is index awareness in universe?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
what is the difference between MOLAP and ROLAP?
suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?
What is analytical or analytic mean?
Explain the main differences between star and snowflake schema?
What is aggregate fact table?
What is data warehouse architecture?
How can you clear the cache?
Explain conformed fact?
Teradata 
