|
AutomateDV advise
|
|
0
|
8
|
5 September 2025
|
|
Teasing Business Keys out of variants of the Entity - Hotels!
|
|
2
|
106
|
29 April 2025
|
|
Clarification on src_eff: "EFFECTIVE_FROM" in Staging Files
|
|
3
|
68
|
21 March 2025
|
|
[Need Advice] Sat Table Reloading Stretegy
|
|
1
|
43
|
11 February 2025
|
|
How should I model Customer/Invoice relationship?
|
|
3
|
142
|
4 February 2025
|
|
How to merge the same entity from another sources
|
|
4
|
243
|
23 October 2024
|
|
How to convert Unix seconds to date type in staging macro
|
|
1
|
50
|
15 October 2024
|
|
Bridge pseudo code
|
|
10
|
849
|
9 September 2024
|
|
Should HUB be loaded only from actual source and how to define- biz. key if 2 source have diff. keys
|
|
5
|
141
|
3 July 2024
|
|
Need some real/sample examples of Information Mart using Raw and Business vault
|
|
10
|
1099
|
1 July 2024
|
|
Sub-sequence Number generation for Multi-active
|
|
43
|
1211
|
28 May 2024
|
|
Re-using business keys across hubs? Or use child dependent key?
|
|
1
|
245
|
27 February 2024
|
|
Loading the same HUB as part of two different DBT jobs
|
|
13
|
546
|
13 December 2023
|
|
Handling "Expected" Duplicates
|
|
4
|
772
|
6 December 2023
|
|
Loading of Historical Snapshots Data Into a Data Vault 2.0
|
|
5
|
605
|
28 August 2023
|
|
Normal or MA Sat
|
|
3
|
243
|
22 August 2023
|
|
START_DATE and END_DATE in EFF_SAT macro
|
|
17
|
766
|
6 June 2023
|
|
Which is the best model to create Information mart on Raw data vault in Big query
|
|
6
|
936
|
23 February 2023
|
|
Reference the downstream Effectivity Satellite in the upstream Raw Staging table
|
|
1
|
255
|
20 February 2023
|
|
vault_insert_by_rank base load only inserts rank 1 on sat
|
|
1
|
242
|
7 February 2023
|
|
How to design data vault in case of multiple source systems and many satellites for each source
|
|
3
|
2128
|
5 February 2023
|
|
Effective From vs Applied Date
|
|
9
|
1255
|
26 September 2022
|
|
New column additions to SAT, and the HASHDIFF in dbtvault
|
|
27
|
3394
|
20 September 2022
|
|
Integrating Business entities from two different systems into one HUB
|
|
23
|
1208
|
13 June 2022
|
|
Dbtvault macro for loading HUB from two different source with different number of BKs
|
|
5
|
305
|
10 June 2022
|
|
WhereScape RED collisions with multiple modelers (using DV)
|
|
3
|
324
|
24 May 2022
|
|
DBTvault Test for the SAT HASHDIFF
|
|
1
|
437
|
25 April 2022
|
|
The dbtvault Data Vault automation tool
|
|
4
|
740
|
20 April 2022
|
|
Multi-active data as Document SATs using dbtvault
|
|
5
|
344
|
23 February 2022
|
|
How do i build the Business Vault with dbtvault?
|
|
2
|
739
|
7 December 2021
|