DV2 Data Warehouse Methodology

Data Vault Anti-pattern: Adding Relationship Temporality to a Non-historised LINK

Non-historised Links represent data can not change or be deleted, for e.g. Stock Trades, Medical Test results etc. This data, once recorded, should not change. As such, there is no need to capture the End date of these. If you find yourself having the need to add the End Date to a LINK table, then it must be a Historized Link.
, , ,

0 responses to “Data Vault Anti-pattern: Adding Relationship Temporality to a Non-historised LINK”

W3CSSPress