Sample Header Ad - 728x90

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

3 votes
0 answers
52 views
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 relationship is deleted in a source system, should this be recorded only by setting the DateExpired field in the link's satellite table(s), or should one also maintain a DateDeleted field in the link table? Note that I'm asking about "better" from a "Data Vault best practices" perspective. For a specific application there may be good reasons to favor one approach or the other.
Asked by Jon of All Trades (5987 rep)
Feb 10, 2017, 07:23 PM