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
Where we use surrogate key explain with example?
What are the tools available for etl?
What is incremintal loading?
What are the steps of implementing data warehousing?
Explain what are fact, dimension, and measure?
What is ods (operation data source)?
Explain what are components of report studio?
What is the extension of file to save template?
Can we take backup when the database is opened?
Which are the olap tools available that are supported by oracle?
Explain meta data?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
what is user variable in affinium campaign? and some real time examples.
What function should we use to display the value entered or selected by a user in response to a prompt?
What are the stages of datawarehousing?