|
Satellite loading Insert statement standard
|
|
9
|
1377
|
22 February 2023
|
|
Same-As Link Advice
|
|
6
|
1112
|
21 February 2023
|
|
How would you link address to metro based on zip code?
|
|
3
|
375
|
21 February 2023
|
|
Should Business Key be included in the SAT HASHDIFF? Also what about Depedent Child in the HASHDIFF for LINK SAT
|
|
18
|
1189
|
21 February 2023
|
|
Reference the downstream Effectivity Satellite in the upstream Raw Staging table
|
|
1
|
251
|
20 February 2023
|
|
SAP system to Data vault
|
|
2
|
774
|
19 February 2023
|
|
Timezone for the timestamp columns
|
|
4
|
506
|
15 February 2023
|
|
What would be the data vault of this data model?
|
|
2
|
550
|
8 February 2023
|
|
vault_insert_by_rank base load only inserts rank 1 on sat
|
|
1
|
235
|
7 February 2023
|
|
For JSON Source if there is a LINK why need HUB and SAT ?
|
|
3
|
348
|
6 February 2023
|
|
Steaming data into data vault 2.0
|
|
1
|
211
|
5 February 2023
|
|
Data Vault 2.0 model for Oracle EBS flex fields and Combination segments
|
|
1
|
300
|
5 February 2023
|
|
Reference Data Models
|
|
4
|
534
|
5 February 2023
|
|
How to design data vault in case of multiple source systems and many satellites for each source
|
|
3
|
2024
|
5 February 2023
|
|
Source attributes pivoted - unpivot?
|
|
1
|
233
|
5 February 2023
|
|
Hub Modelling: Salesforce Healthcloud - Account, Lead, and Contact Objects
|
|
1
|
410
|
5 February 2023
|
|
Loading Pre-aggregated Data into Raw Vault.
|
|
3
|
445
|
5 February 2023
|
|
Reason for Record Source Column in Link tables
|
|
4
|
574
|
24 January 2023
|
|
DV modeling with sereval sources and no nice business key
|
|
14
|
486
|
19 January 2023
|
|
PIT for SAT of multiple Hubs
|
|
2
|
402
|
21 December 2022
|
|
Does DV make sense if all sources are snapshotted ?
|
|
2
|
280
|
18 December 2022
|
|
Looking for dbtvault expert to help resolve some issues
|
|
1
|
248
|
8 December 2022
|
|
Articles from https://danlinstedt.com/allposts/
|
|
3
|
304
|
5 December 2022
|
|
Varying Business Keys
|
|
4
|
1187
|
2 December 2022
|
|
POLL: Which of the following Data Vault books have you read?
|
|
11
|
1147
|
2 December 2022
|
|
What to Do When Your Org Deviates from the Standard
|
|
5
|
324
|
30 November 2022
|
|
How to do 100% insert only soft delete? (Record Source Tracking)
|
|
3
|
930
|
24 November 2022
|
|
To subtype or not
|
|
8
|
379
|
16 November 2022
|
|
PII data for Business Keys
|
|
10
|
274
|
9 November 2022
|
|
Modeling Dictionaries/Hash tables (Key/Value Pairs)
|
|
5
|
271
|
5 November 2022
|