Data Vault Point In Time

Definition: Snapshot Table

Focus: it is focused on A HUB, and it's immediate surrounding Satellites

Where it belongs:

  • in Data Vault 1.0 - it was part of the Raw Data Vault
  • in Data Vault 2.0 - it is now included in the Business Vault

Purposes:
1. to provide faster query access
2. to buffer end-users from real-time streaming data
3. to provide rapid access to pre-calculated attributes
4. to enable virtualization of information marts

Does it contain auditable data? No

Loads to this table ARE NOT delta driven

DV1.0 Structure Contains:
Snapshot Date+time (PK)
Hub Sequence
Hub Business Key
<Satellite 1 Load Date>
<Satellite N Load Date>
** Optional:
<computed fields>

DV2.0 Structure Contains:
Snapshot Date+time (PK)
Hub Hash Key
Hub Business Key
<Satellite 1 Load Date>
<Satellite N Load Date>
** Optional:
<computed fields>

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License