Questions tagged [data-vault]

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

Filter by
Sorted by
Tagged with
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 ...
Nika's user avatar
  • 43
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 ...
Jon of All Trades's user avatar
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 ...
Jon of All Trades's user avatar