Interested to Buy Any Domain ? << Click Here >> for more details...
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 needs to be done while starting the database?
Explain what is the difference between view filter and report filter?
How can you implement many relations in star schema model?
Can you state some of the innovations throughout history?
Explain how many ways you create ports?
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.
What is index awareness in universe?
What is data type of the surrogate key?
Explain the hierarchies level data warehousing.
How can we run the graph? What is the procedure for that?
Code the tables statement for a single-level (most common) frequency?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
What is dimensional modelling?
Explain what is the metadata extension?
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?
