Data Vault Satellite

Definition: Contains descriptive data over time

Requirement: at least but no more than ONE parent table (ie: Hub or Link)
Requirement: NO SNOWFLAKING… EVER
Requirement: NO FOREIGN KEYS ** note: implied but not implemented FK's for reference codes **

DV1.0 Structure Contains:
Hub or Link Sequence (PK)
Load Date + Milliseconds time (PK)
Load End Date + Time (attribute)
Record Source
<User driven fields>

DV2.0 Structure Contains:
Hub or Link Hash Key (PK)
Load Date + Milliseconds time (PK)
Load End Date + Time (attribute)
Record Source
<User driven fields>

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