Google News
logo
ETL Testing - Interview Questions
What are snapshots in ETL?
Snapshots are read-only copies of data from the master table. Before a change to the data warehouse is made, a snapshot is taken and stored locally for reference. This works to preserve records as they were before the change was made.
 
Each snapshot has three components :
 
* The time it was taken
* A key to identify the snapshot
* The data relating to the key
Advertisement