Answer Posted / 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 |
Post New Answer View All Answers
What are data modeling and data mining? Where it will be used?
Explain what is the advantages data mining over traditional approaches?
Start a batches with in a batch?
What is the definition of cube in datawarehousing?
Explain the difference between view and materialized view?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
How to provide security in frame work manager for a query subject?
What are steps we have to follow in designing the userfriendly universe?
What is many-to-many dimensional model in datawarehousing ?
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
Explain what are the different types of join operations?
What are components of reportnet?
What are the different methods of loading dimension tables?
What is bi?
What are the various transformation available?