Questions tagged [data-vault]

A specific data warehousing approach; not to be confused with data security in general.

A "Data Vault" or the "data vault modeling" approach refer to a specific data warehousing strategy, pioneered by Dan Linstedt. It is built around "Hub," "Link," and "Satellite" tables, a highly normalized approach which attempts to provide strong auditing, efficient loading, flexible architecture, and support for downstream data marts (e.g., star schemas).

3 questions
3
votes
0 answers

If a relationship is (logically) deleted, is this marked in the link table or just the satellite table(s)?

I'm learning about the Data Vault data warehousing approach, and so far the examples I've seen have a DateLoaded or similar field in all tables (hub, link, and satellite), but a DateExpired or EndDate field only in satellite tables. If a…
Jon of All Trades
  • 5,987
  • 7
  • 48
  • 63
1
vote
0 answers

Is the source system typically one of the fields used to uniquely identify business key?

One of the key components of designing a data vault is identifying enterprise-wide unique business keys ("business key" AKA "natural key"). It's not enough to use OrderID to identify records in an Orders table, because when you add another orders…
0
votes
2 answers

Is there a recommended order to create a DV model and star schema?

I want to create and implement a Data Vault Model. In the presentation layer, I want to create a View based on a star schema. Now I would like to know if there is a certain order in creating the models in practice? (Is is a commonplace to create…