What are snapshots? What are materialized views & where do we use them?
- 1 Answers
- 1140 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the purpose of Dataware Control?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
Explain how to generate iqd file from framework manager?
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
