|
What are PIT & Bridge Tables?
|
|
13
|
12439
|
August 15, 2022
|
|
Zero Key in Hub
|
|
21
|
3399
|
July 24, 2023
|
|
New column additions to SAT, and the HASHDIFF in dbtvault
|
|
27
|
3926
|
September 20, 2022
|
|
Modeling a dependent child
|
|
11
|
4579
|
March 13, 2022
|
|
More than one record in SAT for a Business Key with the same LOAD_DATE in a single load
|
|
32
|
2356
|
October 11, 2023
|
|
Introduce yourselves!
|
|
49
|
1799
|
November 11, 2026
|
|
Modelling Question on DV2.0
|
|
27
|
2339
|
December 14, 2023
|
|
Sub-sequence Number generation for Multi-active
|
|
43
|
1793
|
May 28, 2024
|
|
DV Modelling Is Hard
|
|
9
|
361
|
May 30, 2026
|
|
HUB Creation from Multiple Source system
|
|
15
|
2769
|
June 11, 2022
|
|
Resolving Hash collision
|
|
13
|
2903
|
June 5, 2023
|
|
POLL: Which of the following Data Vault books have you read?
|
|
11
|
1517
|
December 2, 2022
|
|
Need some real/sample examples of Information Mart using Raw and Business vault
|
|
10
|
1583
|
July 1, 2024
|
|
Can I restructure source data before loading it into the raw vault?
|
|
18
|
2028
|
April 3, 2022
|
|
Integrating Business entities from two different systems into one HUB
|
|
23
|
1756
|
June 13, 2022
|
|
Multi-Active Satellite or Weak Hub + Link?
|
|
10
|
2368
|
June 22, 2022
|
|
Super Type and sub type
|
|
9
|
2341
|
June 3, 2024
|
|
New Domain, Hash Key Question for the HUBs
|
|
9
|
1286
|
September 21, 2022
|
|
Same as across different sources that hold the data differently
|
|
13
|
1814
|
February 29, 2024
|
|
Is there any precedence for a single table (self-referencing?) LINK?
|
|
29
|
1234
|
December 2, 2025
|
|
relationship between one hub and satellite of another hub
|
|
13
|
1763
|
March 26, 2024
|
|
Why are hubs, links and satellites separate tables?
|
|
30
|
1177
|
August 10, 2025
|
|
Should Business Key be included in the SAT HASHDIFF? Also what about Depedent Child in the HASHDIFF for LINK SAT
|
|
18
|
1472
|
February 21, 2023
|
|
RTS for Sat with dependent child
|
|
13
|
962
|
June 1, 2022
|
|
Tracking deletes in a regular satellite
|
|
9
|
1824
|
June 21, 2023
|
|
Enddate and IsCurrent Columns
|
|
11
|
1629
|
July 11, 2023
|
|
Non historized link use case and certification
|
|
12
|
1526
|
April 18, 2023
|
|
Satellite loading Insert statement standard
|
|
9
|
1722
|
February 22, 2023
|
|
How to parallelize hubs and links loads and automatize them as much as possible ?
|
|
11
|
1537
|
March 27, 2023
|
|
Technical Advice on SAL and PIT Related to Same Hub
|
|
23
|
1067
|
June 19, 2023
|
|
Effective From vs Applied Date
|
|
9
|
1629
|
September 26, 2022
|
|
Creating information mart table from a Link-Sat with history
|
|
14
|
1173
|
July 1, 2024
|
|
Why the Business Key should not reside in the SAT?
|
|
9
|
797
|
April 7, 2022
|
|
START_DATE and END_DATE in EFF_SAT macro
|
|
17
|
1032
|
June 6, 2023
|
|
How to model website tracking data in DV 2.0
|
|
18
|
901
|
March 2, 2024
|
|
Creating Multiple Status Tracking Satellites associated to the same hub
|
|
10
|
1173
|
November 3, 2023
|
|
Query optimization for the Link SAT with Dependent Child
|
|
12
|
1007
|
June 7, 2022
|
|
Bridge pseudo code
|
|
10
|
1025
|
September 9, 2024
|
|
Loading the same HUB as part of two different DBT jobs
|
|
13
|
845
|
December 13, 2023
|
|
Zero key as ghost record hash key?
|
|
11
|
850
|
January 22, 2024
|
|
Optimizing SAT Loading from Staging as a VIEW in Snowflake
|
|
15
|
713
|
August 5, 2022
|
|
DV modeling with sereval sources and no nice business key
|
|
14
|
733
|
January 19, 2023
|
|
Two or more dependent children in a LINK?
|
|
15
|
690
|
March 13, 2022
|
|
How to design Raw Vault for Ledger Summary and Ledger Line item tables?
|
|
13
|
716
|
February 24, 2022
|
|
What's the best approach for removing columns from a satellite?
|
|
17
|
571
|
August 8, 2025
|
|
Modelling Question on Business Key Updating in source system
|
|
9
|
736
|
September 19, 2022
|
|
Modeling question on Child Key on Data Vault 2.0
|
|
11
|
668
|
July 6, 2023
|
|
naming and splitting satellite tables
|
|
11
|
650
|
May 11, 2024
|
|
Questions regarding applied timestamp
|
|
12
|
351
|
February 5, 2026
|
|
Alternative for MSAT containing very big sets
|
|
12
|
614
|
November 4, 2023
|