What are snapshots? What are materialized views & where do we use them?
- 1 Answers
- 1145 Views
- I also Faced
- E-Mail Answers
Answer / Rama Shankar Karn
1) Snapshots: A snapshot is a read-only copy of data at a specific point in time. In the context of data warehousing, snapshots can be used to compare data between different periods or to capture the state of a database for backup purposes. 2) Materialized Views (MV): An MV is a pre-computed and stored result set based on a SELECT statement in a database. It acts as a faster substitute for complex queries by providing a summarized version of data. Materialized views are useful when querying large amounts of data repeatedly, as they reduce the need to recompute results.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a relationship?
What is hash partition?
What is normalization, first normal form, second normal form, third normal form?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
4 Answers IBM, MAHINDRA, Tech Mahindra,
What are modeling tools available in the market?
What is the differences between star and snowflake schemas?
In datastage can ve find the job based on source table name ??
What are the stages of datawarehousing?
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
What is the purpose of cluster analysis in data warehousing?
What is difference between Business Objects and Hyperion Essbase? Please help me
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?
Teradata 
