Data warehousing - What is snapshot with reference to data warehouse?

What is snapshot with reference to data warehouse?

A snapshot of data warehouse is a persisted report from the catalogue. The persistence into a file is done after disconnecting report from the catalogue.

What is snapshot with reference to data warehouse?

A snapshot is in a data warehouse can be used to track activities. For example, every time an employee attempts to change his address, the data warehouse can be alerted for a snapshot. This means that each snap shot is taken when some event is fired.

A snapshot has three components –

Time when event occurred.
A key to identify the snap shot.
Data that relates to the key.
Data warehousing - What is degenerate dimension table?
What is degenerate dimension table? - The dimensions that are persisted in the fact table is called dimension table........
Data warehousing - What is Data Mart?
What is Data Mart? - Data Mart is a data repository which is served to a community of people......
Data warehousing - difference between metadata and data dictionary
Difference between metadata and data dictionary - Metadata describes about data. It is ‘data about data’. It has information about how and when......
Post your comment