|
Modeling alternate ids in hub - BKCC?
|
|
3
|
1308
|
June 30, 2022
|
|
Dropping historical entries in a computed satellite?
|
|
5
|
1061
|
November 7, 2023
|
|
How to determine if a unique hub/satelite is needed
|
|
5
|
988
|
November 2, 2023
|
|
PII value is being used for Business Key
|
|
6
|
904
|
July 3, 2023
|
|
Dealing with NVARCHAR(MAX) Columns in Hash Calculations Azure Synapse DB
|
|
5
|
960
|
April 12, 2023
|
|
How to do 100% insert only soft delete? (Record Source Tracking)
|
|
3
|
1171
|
November 24, 2022
|
|
Data Vault Database schema
|
|
6
|
865
|
March 8, 2023
|
|
How to Integrate Same-As-Links into PITs
|
|
5
|
911
|
August 18, 2023
|
|
Data Mesh - and what it bodes for Data Vault in the future
|
|
7
|
781
|
August 3, 2022
|
|
Use Date as Dependent Child (Forecasts, historical data)
|
|
2
|
397
|
June 29, 2023
|
|
Handling "Expected" Duplicates
|
|
4
|
964
|
December 6, 2023
|
|
How to Implement Hard and Soft Rules
|
|
4
|
963
|
April 23, 2022
|
|
The dbtvault Data Vault automation tool
|
|
4
|
928
|
April 20, 2022
|
|
How to model an empty list in multi-active satellite?
|
|
7
|
729
|
September 19, 2022
|
|
One or More Hubs for same Entity
|
|
2
|
666
|
August 21, 2023
|
|
Handling relationship between parties in Data Vault
|
|
7
|
718
|
January 3, 2024
|
|
Tracking number of INSERTs into HUB, LINK and Satellite
|
|
6
|
421
|
January 29, 2022
|
|
Loading of Historical Snapshots Data Into a Data Vault 2.0
|
|
5
|
783
|
August 28, 2023
|
|
Non-historized or normal link
|
|
6
|
704
|
April 16, 2023
|
|
Tracking status for a dependent child data
|
|
4
|
820
|
July 8, 2022
|
|
How should I model Customer/Invoice relationship?
|
|
3
|
285
|
February 4, 2025
|
|
Linking User Hub to Numerous Other Hubs By CreatedBy/LastModifiedBy
|
|
7
|
636
|
June 22, 2022
|
|
Data Vault Certification
|
|
3
|
896
|
September 2, 2022
|
|
Handling erroneous input data
|
|
8
|
592
|
March 14, 2023
|
|
How to distinguish between a business key or standard satellite attribute
|
|
5
|
714
|
January 30, 2024
|
|
Code template to use effectivity satellites for multiple sources
|
|
8
|
582
|
September 4, 2023
|
|
DV2 Naming Standards
|
|
2
|
1008
|
July 21, 2022
|
|
CRM Data Vault Model
|
|
6
|
656
|
January 12, 2024
|
|
data vault modeling : staging layer
|
|
5
|
680
|
September 18, 2024
|
|
Top 10 Worst IT technologies
|
|
3
|
263
|
May 28, 2022
|
|
How do i build the Business Vault with dbtvault?
|
|
2
|
921
|
December 7, 2021
|
|
Modeling Functional Roles
|
|
6
|
601
|
July 7, 2022
|
|
Crowd Sourcing: Best Practice in Dimensional Modeling on top of DV
|
|
4
|
708
|
October 27, 2023
|
|
Including additional keys as primary keys in satellite
|
|
3
|
786
|
March 10, 2024
|
|
Create End Date time in Satellites without windows function
|
|
1
|
348
|
April 10, 2024
|
|
Reason for Record Source Column in Link tables
|
|
4
|
692
|
January 24, 2023
|
|
How to model inventory in an ERP
|
|
5
|
629
|
February 9, 2022
|
|
Articles from https://danlinstedt.com/allposts/
|
|
3
|
425
|
December 5, 2022
|
|
SAP system to Data vault
|
|
2
|
873
|
February 19, 2023
|
|
To subtype or not
|
|
8
|
496
|
November 16, 2022
|
|
Why your data architecture is holding your AI back
|
|
0
|
46
|
April 30, 2026
|
|
Same as Link for Dependent Child
|
|
3
|
716
|
May 21, 2022
|
|
Load End Date Time in Satellites
|
|
3
|
715
|
November 18, 2023
|
|
How to create the link when linking keys are non-business keys
|
|
3
|
713
|
September 19, 2022
|
|
Approach for handling the need for "pre-join"
|
|
6
|
537
|
March 13, 2023
|
|
Raw Vault to Information Layer (Dim) Questions
|
|
4
|
634
|
October 10, 2023
|
|
Timezone for the timestamp columns
|
|
4
|
611
|
February 15, 2023
|
|
Data vault schema evolution question
|
|
6
|
516
|
January 31, 2024
|
|
Skip hubs in joins
|
|
3
|
680
|
August 7, 2022
|
|
Need help with complicate relationship data
|
|
6
|
515
|
October 11, 2023
|