Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
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 meetthe condition.
a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron
Explain what is the main difference between inmon and kimball philosophies of data warehousing?
What are the advantages of cold fusion?
what are different storage options supported by oracle ?
What is the purpose of cluster analysis in data warehousing?
Explain how to get the first 100 rows from the flat file into the target?
Explain differences between star and snowflake schemas?
Explain difference between view and materialized view?
Tell me what is full load & incremental or refresh load?
Is there any default username & pwd for bo designer & supervisor?
How to know the time taken for particular report execution?
What is the difference between snowflake and star schema?
Explain what is the difference between powerplay transformer and power play reports?
What needs to be done while starting the database?
