# Top

**URL:** https://forum.data-community.org/top.md

[Latest](https://forum.data-community.org/latest.md) · [Categories](https://forum.data-community.org/categories.md) · [Tags](https://forum.data-community.org/tags.md)

---

## [What are PIT & Bridge Tables?](https://forum.data-community.org/t/what-are-pit-bridge-tables/164)

<div class="topic-metadata">

**Author:** [@anon83229795](https://forum.data-community.org/u/anon83229795)\
**Replies:** 13\
**Last updated:** [August 15, 2022, 4:43am UTC](https://forum.data-community.org/t/what-are-pit-bridge-tables/164 "2022-08-15T04:43:51Z")

</div>

Could you please help me to understand what are PIT and bridge tables and when would I use them? (This is one of the questions that was asked during our last meetup "5 most common challenges with Data Vault modelling on…

---

## [Zero Key in Hub](https://forum.data-community.org/t/zero-key-in-hub/242)

<div class="topic-metadata">

**Author:** [@Bigguy365](https://forum.data-community.org/u/Bigguy365)\
**Replies:** 21\
**Last updated:** [July 24, 2023, 10:24pm UTC](https://forum.data-community.org/t/zero-key-in-hub/242 "2023-07-24T22:24:57Z")

</div>

I’m having a hard time understanding when in a hub you would create a record in the raw vault if you didn’t know what the record key value(s) are. I can understand coming up with this situation in the staging area but n…

---

## [New column additions to SAT, and the HASHDIFF in dbtvault](https://forum.data-community.org/t/new-column-additions-to-sat-and-the-hashdiff-in-dbtvault/240)

<div class="topic-metadata">

**Author:** [@saqib](https://forum.data-community.org/u/saqib)\
**Replies:** 27\
**Last updated:** [September 20, 2022, 1:20pm UTC](https://forum.data-community.org/t/new-column-additions-to-sat-and-the-hashdiff-in-dbtvault/240 "2022-09-20T13:20:26Z")

</div>

Hello, When it comes to adding new columns to an existing SAT, Dan recommends to put the new columns at the end of the SAT and the HASHDIFF such that, “Columns that are NULL and at the end of the table are not added to …

---

## [Modeling a dependent child](https://forum.data-community.org/t/modeling-a-dependent-child/197)

<div class="topic-metadata">

**Author:** [@saqib](https://forum.data-community.org/u/saqib)\
**Replies:** 11\
**Last updated:** [March 13, 2022, 9:04pm UTC](https://forum.data-community.org/t/modeling-a-dependent-child/197 "2022-03-13T21:04:08Z")

</div>

Hello all, We have a business process where the the Manufacturer is a Dependent Child i.e. it only holds meaning when tied to a Dept. We are planning to add that Manufacturer ID to the LINK\_ table as a dependent key as …

---

## [More than one record in SAT for a Business Key with the same LOAD\_DATE in a single load](https://forum.data-community.org/t/more-than-one-record-in-sat-for-a-business-key-with-the-same-load-date-in-a-single-load/220)

<div class="topic-metadata">

**Author:** [@saqib](https://forum.data-community.org/u/saqib)\
**Replies:** 32\
**Last updated:** [October 11, 2023, 2:12pm UTC](https://forum.data-community.org/t/more-than-one-record-in-sat-for-a-business-key-with-the-same-load-date-in-a-single-load/220 "2023-10-11T14:12:21Z")

</div>

Hello We have a situation where our ETL load process can bring multiple records for the same Business Key in a single load. Each of these record represent a change to the descriptive attributes of the Business Key. If …

---

## [Introduce yourselves!](https://forum.data-community.org/t/introduce-yourselves/20)

<div class="topic-metadata">

**Author:** [@richard.strange](https://forum.data-community.org/u/richard.strange)\
**Replies:** 49\
**Last updated:** [November 11, 2026, 10:13am UTC](https://forum.data-community.org/t/introduce-yourselves/20 "2026-11-11T10:13:57Z")

</div>

New to the user group? Say hello here!

---

## [Modelling Question on DV2.0](https://forum.data-community.org/t/modelling-question-on-dv2-0/341)

<div class="topic-metadata">

**Author:** [@preddy](https://forum.data-community.org/u/preddy)\
**Replies:** 27\
**Last updated:** [December 14, 2023, 10:20am UTC](https://forum.data-community.org/t/modelling-question-on-dv2-0/341 "2023-12-14T10:20:48Z")

</div>

We are doing a POC using DV 2.0 , Please advise. 1)Can I have only one HUBKEY with dependent child in LINK table? The reason I was asking is we can have Multiple instance of same policynumber (Policynumber is HUBKEY) …

---

## [Sub-sequence Number generation for Multi-active](https://forum.data-community.org/t/sub-sequence-number-generation-for-multi-active/257)

<div class="topic-metadata">

**Author:** [@saqib](https://forum.data-community.org/u/saqib)\
**Replies:** 43\
**Last updated:** [May 28, 2024, 11:31pm UTC](https://forum.data-community.org/t/sub-sequence-number-generation-for-multi-active/257 "2024-05-28T23:31:23Z")

</div>

Hello, We have a Multi-Active SAT that houses statuses. While the statuses have temp-orality, multiples statues can exists at the same time. For this purpose we have added a Sub-sequence Number for each Status that exis…

---

## [DV Modelling Is Hard](https://forum.data-community.org/t/dv-modelling-is-hard/2055)

<div class="topic-metadata">

**Author:** [@JustOneCog](https://forum.data-community.org/u/JustOneCog)\
**Replies:** 9\
**Last updated:** [May 30, 2026, 4:45am UTC](https://forum.data-community.org/t/dv-modelling-is-hard/2055 "2026-05-30T04:45:38Z")

</div>

Hi all, Apologies in advance for my rant below. So I’m one cog in a machine that is trying to build a data vault. The machine has been running for a while now and I’m coming in a bit blind. I’m doing my best to underst…

---

## [HUB Creation from Multiple Source system](https://forum.data-community.org/t/hub-creation-from-multiple-source-system/275)

<div class="topic-metadata">

**Author:** [@preddy](https://forum.data-community.org/u/preddy)\
**Replies:** 15\
**Last updated:** [June 11, 2022, 5:20pm UTC](https://forum.data-community.org/t/hub-creation-from-multiple-source-system/275 "2022-06-11T17:20:51Z")

</div>

we are starting to Implement a DV 2.0 in our company, Could anyone please help me to understand designing the HUB tables whether I need single hub or multiple hub. we have policy data from 2 different source systems, F…

---

## [Resolving Hash collision](https://forum.data-community.org/t/resolving-hash-collision/493)

<div class="topic-metadata">

**Author:** [@Nikunj](https://forum.data-community.org/u/Nikunj)\
**Replies:** 13\
**Last updated:** [June 5, 2023, 9:34am UTC](https://forum.data-community.org/t/resolving-hash-collision/493 "2023-06-05T09:34:08Z")

</div>

Hello All, I understand that the MD5, SHA1 or SHA256 are some of the hash algorithms used for generating hash keys for business key. we all know that there is a minor risk of collision and the risk reduces (not complet…

---

## [POLL: Which of the following Data Vault books have you read?](https://forum.data-community.org/t/poll-which-of-the-following-data-vault-books-have-you-read/130)

<div class="topic-metadata">

**Author:** [@Nicruzer](https://forum.data-community.org/u/Nicruzer)\
**Replies:** 11\
**Last updated:** [December 2, 2022, 9:30am UTC](https://forum.data-community.org/t/poll-which-of-the-following-data-vault-books-have-you-read/130 "2022-12-02T09:30:00Z")

</div>

Which of the following three Data Vault books have you read? poll Continue the discussion...If you have read more than one of the books listed in the poll, which would you recommend first to someone wanting to learn mor…

---

## [Need some real/sample examples of Information Mart using Raw and Business vault](https://forum.data-community.org/t/need-some-real-sample-examples-of-information-mart-using-raw-and-business-vault/893)

<div class="topic-metadata">

**Author:** [@Irfan](https://forum.data-community.org/u/Irfan)\
**Replies:** 10\
**Last updated:** [July 1, 2024, 7:30am UTC](https://forum.data-community.org/t/need-some-real-sample-examples-of-information-mart-using-raw-and-business-vault/893 "2024-07-01T07:30:42Z")

</div>

Hi, I need real examples of converting a raw data vault into Information Mart (star schema). All the examples I found on the internet are too simple. I need to know the following. Using PIT and Satellites to create a …

---

## [Can I restructure source data before loading it into the raw vault?](https://forum.data-community.org/t/can-i-restructure-source-data-before-loading-it-into-the-raw-vault/139)

<div class="topic-metadata">

**Author:** [@anon83229795](https://forum.data-community.org/u/anon83229795)\
**Replies:** 18\
**Last updated:** [April 3, 2022, 10:26pm UTC](https://forum.data-community.org/t/can-i-restructure-source-data-before-loading-it-into-the-raw-vault/139 "2022-04-03T22:26:15Z")

</div>

Am I taking the guidance that raw vault data should be unmodified by business logic too literally by assuming that it also applies to not restructuring source data based on our understanding of it? Could alternatives re…

---

## [Integrating Business entities from two different systems into one HUB](https://forum.data-community.org/t/integrating-business-entities-from-two-different-systems-into-one-hub/300)

<div class="topic-metadata">

**Author:** [@saqib](https://forum.data-community.org/u/saqib)\
**Replies:** 23\
**Last updated:** [June 13, 2022, 8:14pm UTC](https://forum.data-community.org/t/integrating-business-entities-from-two-different-systems-into-one-hub/300 "2022-06-13T20:14:12Z")

</div>

We have two different systems that provide Opportunity Data. The Business Keys that identify an Opportunity is very different in the two systems. One system uses OPP\_NUM + OPP\_MONTH + OPP\_YEAR as the Business Key and the…

---

## [Multi-Active Satellite or Weak Hub + Link?](https://forum.data-community.org/t/multi-active-satellite-or-weak-hub-link/330)

<div class="topic-metadata">

**Author:** [@FrenkLoonen](https://forum.data-community.org/u/FrenkLoonen)\
**Replies:** 10\
**Last updated:** [June 22, 2022, 5:54pm UTC](https://forum.data-community.org/t/multi-active-satellite-or-weak-hub-link/330 "2022-06-22T17:54:17Z")

</div>

Which flavor do you guys like best? I have two tables: Customer\_Core with PK CustomerID that I load into Hub\_Customer and Sat\_Customer Customer\_Additional with PK CustomerID+Method+Number Method is always a 2-charact…

---

## [Super Type and sub type](https://forum.data-community.org/t/super-type-and-sub-type/574)

<div class="topic-metadata">

**Author:** [@Nikunj](https://forum.data-community.org/u/Nikunj)\
**Replies:** 9\
**Last updated:** [June 3, 2024, 2:05pm UTC](https://forum.data-community.org/t/super-type-and-sub-type/574 "2024-06-03T14:05:28Z")

</div>

Need some guidance on modelling a supertype and its subtype in the data vault. I need to model super types and sub types for the data vault. I would like to get a perspective on how other forum members look modelling s…

---

## [New Domain, Hash Key Question for the HUBs](https://forum.data-community.org/t/new-domain-hash-key-question-for-the-hubs/216)

<div class="topic-metadata">

**Author:** [@jjs88](https://forum.data-community.org/u/jjs88)\
**Replies:** 9\
**Last updated:** [September 21, 2022, 1:11am UTC](https://forum.data-community.org/t/new-domain-hash-key-question-for-the-hubs/216 "2022-09-21T01:11:22Z")

</div>

Hello all, I’m building out a new domain in DV and have a question regarding Hash Keys for the HUBs. SHA1 is being deprecated in SQL Server so I’m wondering if it makes sense to use that for HK purposes in the model go…

---

## [Same as across different sources that hold the data differently](https://forum.data-community.org/t/same-as-across-different-sources-that-hold-the-data-differently/646)

<div class="topic-metadata">

**Author:** [@andy](https://forum.data-community.org/u/andy)\
**Replies:** 13\
**Last updated:** [February 29, 2024, 10:17pm UTC](https://forum.data-community.org/t/same-as-across-different-sources-that-hold-the-data-differently/646 "2024-02-29T22:17:19Z")

</div>

Hi, I’m relatively new to DV2.0 and I’m hoping to understand a few things that I’m having trouble finding resources for online. I’ll keep them as separate threads so as not to confuse. We have two Kafka event streams a…

---

## [Is there any precedence for a single table (self-referencing?) LINK?](https://forum.data-community.org/t/is-there-any-precedence-for-a-single-table-self-referencing-link/930)

<div class="topic-metadata">

**Author:** [@damn\_yankee](https://forum.data-community.org/u/damn_yankee)\
**Replies:** 29\
**Last updated:** [December 2, 2025, 1:14am UTC](https://forum.data-community.org/t/is-there-any-precedence-for-a-single-table-self-referencing-link/930 "2025-12-02T01:14:10Z")

</div>

For a definition of a LINK in DV 2.0, I always see the phrase “A link is a connection to 2 or more hubs”, or some such, but I want to create a single table link. Something akin to a “self referencing foreign key” from t…

---

## [relationship between one hub and satellite of another hub](https://forum.data-community.org/t/relationship-between-one-hub-and-satellite-of-another-hub/1214)

<div class="topic-metadata">

**Author:** [@Sudi](https://forum.data-community.org/u/Sudi)\
**Replies:** 13\
**Last updated:** [March 26, 2024, 9:44am UTC](https://forum.data-community.org/t/relationship-between-one-hub-and-satellite-of-another-hub/1214 "2024-03-26T09:44:41Z")

</div>

Hello All, In data vault design, I’m facing the relationship between one hub and the satellite of another hub. Is it possible that this situation shows that there is some problem in the model? Please let me know your i…

---

## [Why are hubs, links and satellites separate tables?](https://forum.data-community.org/t/why-are-hubs-links-and-satellites-separate-tables/1746)

<div class="topic-metadata">

**Author:** [@Hook](https://forum.data-community.org/u/Hook)\
**Replies:** 30\
**Last updated:** [August 10, 2025, 10:54pm UTC](https://forum.data-community.org/t/why-are-hubs-links-and-satellites-separate-tables/1746 "2025-08-10T22:54:17Z")

</div>

Hi there, I have reached out to the DV community on many occasions trying to get an answer to this question. I get that hubs, links and satellites are meant to keep business key, relationships and contextual information…

---

## [Should Business Key be included in the SAT HASHDIFF? Also what about Depedent Child in the HASHDIFF for LINK SAT](https://forum.data-community.org/t/should-business-key-be-included-in-the-sat-hashdiff-also-what-about-depedent-child-in-the-hashdiff-for-link-sat/596)

<div class="topic-metadata">

**Author:** [@saqib](https://forum.data-community.org/u/saqib)\
**Replies:** 18\
**Last updated:** [February 21, 2023, 7:07am UTC](https://forum.data-community.org/t/should-business-key-be-included-in-the-sat-hashdiff-also-what-about-depedent-child-in-the-hashdiff-for-link-sat/596 "2023-02-21T07:07:21Z")

</div>

Hi, I have seen Business Keys and Dependent Child included in the HASHDIFF of a SAT or LINK SAT. What is the best practice? Does it make a difference? Thanks, Saqib

---

## [RTS for Sat with dependent child](https://forum.data-community.org/t/rts-for-sat-with-dependent-child/212)

<div class="topic-metadata">

**Author:** [@Christopher](https://forum.data-community.org/u/Christopher)\
**Replies:** 13\
**Last updated:** [June 1, 2022, 10:37pm UTC](https://forum.data-community.org/t/rts-for-sat-with-dependent-child/212 "2022-06-01T22:37:44Z")

</div>

When you have a sat with a dependent child and no CDC, how do you implement a Record Tracking Satellite (RTS)? Normally the RTS sits on the hub and tracks BKs. However, the BK grain is not sufficient to track a dependent…

---

## [Tracking deletes in a regular satellite](https://forum.data-community.org/t/tracking-deletes-in-a-regular-satellite/849)

<div class="topic-metadata">

**Author:** [@FrenkLoonen](https://forum.data-community.org/u/FrenkLoonen)\
**Replies:** 9\
**Last updated:** [June 21, 2023, 10:42pm UTC](https://forum.data-community.org/t/tracking-deletes-in-a-regular-satellite/849 "2023-06-21T22:42:51Z")

</div>

With DV2,0, we only do inserts. When we get full snapshots from a source, we’re able to implement Status Tracking Satellites to track when a record has been deleted. However, when I need to write a business rule to histo…

---

## [Enddate and IsCurrent Columns](https://forum.data-community.org/t/enddate-and-iscurrent-columns/338)

<div class="topic-metadata">

**Author:** [@Bigguy365](https://forum.data-community.org/u/Bigguy365)\
**Replies:** 11\
**Last updated:** [July 11, 2023, 8:51am UTC](https://forum.data-community.org/t/enddate-and-iscurrent-columns/338 "2023-07-11T08:51:15Z")

</div>

Having recently attended the CDV2P training and attaining the CDV2P-Legacy certification, PerfpormanceG2 is providing free of charge the DV101-Baseline Hands-On training course. The material was created in January of 202…

---

## [Non historized link use case and certification](https://forum.data-community.org/t/non-historized-link-use-case-and-certification/738)

<div class="topic-metadata">

**Author:** [@Manu](https://forum.data-community.org/u/Manu)\
**Replies:** 12\
**Last updated:** [April 18, 2023, 12:51pm UTC](https://forum.data-community.org/t/non-historized-link-use-case-and-certification/738 "2023-04-18T12:51:06Z")

</div>

Hello all, First of all, thank you a lot for your help and the resources you make available for free to the community, it’s really appreciated. So I come to you with two major questions. The first one is about a use ca…

---

## [Satellite loading Insert statement standard](https://forum.data-community.org/t/satellite-loading-insert-statement-standard/612)

<div class="topic-metadata">

**Author:** [@Nikunj](https://forum.data-community.org/u/Nikunj)\
**Replies:** 9\
**Last updated:** [February 22, 2023, 9:55pm UTC](https://forum.data-community.org/t/satellite-loading-insert-statement-standard/612 "2023-02-22T21:55:43Z")

</div>

Would like to clarify working of satellite and historical tracking in the satellite table Satellite loading code is as below insert into sat\_person\_address select distinct ‚person\_hash\_key ,loadts ,record\_source …

---

## [How to parallelize hubs and links loads and automatize them as much as possible ?](https://forum.data-community.org/t/how-to-parallelize-hubs-and-links-loads-and-automatize-them-as-much-as-possible/708)

<div class="topic-metadata">

**Author:** [@Sevann](https://forum.data-community.org/u/Sevann)\
**Replies:** 11\
**Last updated:** [March 27, 2023, 8:55am UTC](https://forum.data-community.org/t/how-to-parallelize-hubs-and-links-loads-and-automatize-them-as-much-as-possible/708 "2023-03-27T08:55:31Z")

</div>

Hello everybody, I am pretty new with the data vault modeling and i would like to know if what i am implementing is making sense or not. In my company, we want to implement the data vault in our lakehouse to get better…

---

## [Technical Advice on SAL and PIT Related to Same Hub](https://forum.data-community.org/t/technical-advice-on-sal-and-pit-related-to-same-hub/810)

<div class="topic-metadata">

**Author:** [@andy](https://forum.data-community.org/u/andy)\
**Replies:** 23\
**Last updated:** [June 19, 2023, 10:00pm UTC](https://forum.data-community.org/t/technical-advice-on-sal-and-pit-related-to-same-hub/810 "2023-06-19T22:00:16Z")

</div>

Hi there, Hoping for some technical advice. As background: 4 source systems into an Application Hub Original Salesforce (2010 - 2021) Bespoke System (1990 - present) Application microservice (2018 - present) New Sale…

---

## [Effective From vs Applied Date](https://forum.data-community.org/t/effective-from-vs-applied-date/54)

<div class="topic-metadata">

**Author:** [@alex.higgs](https://forum.data-community.org/u/alex.higgs)\
**Replies:** 9\
**Last updated:** [September 26, 2022, 11:57am UTC](https://forum.data-community.org/t/effective-from-vs-applied-date/54 "2022-09-26T11:57:32Z")

</div>

Hi all Recently at our meetup (December 8th) we announced some new changes to dbtvault. One of these changes was changing “Effective From” in Satellites and Effectivity Satellites to “Applied Date”. “Applied Date” has …

---

## [Creating information mart table from a Link-Sat with history](https://forum.data-community.org/t/creating-information-mart-table-from-a-link-sat-with-history/1036)

<div class="topic-metadata">

**Author:** [@blitz](https://forum.data-community.org/u/blitz)\
**Replies:** 14\
**Last updated:** [July 1, 2024, 7:30am UTC](https://forum.data-community.org/t/creating-information-mart-table-from-a-link-sat-with-history/1036 "2024-07-01T07:30:39Z")

</div>

Hi All, Hope you are well! I have a question on how to create a model in the information mart corresponding to a specific Link-Sat combination. Creating a fact table might be an obvious answer, but the satellite hangin…

---

## [Why the Business Key should not reside in the SAT?](https://forum.data-community.org/t/why-the-business-key-should-not-reside-in-the-sat/179)

<div class="topic-metadata">

**Author:** [@saqib](https://forum.data-community.org/u/saqib)\
**Replies:** 9\
**Last updated:** [April 7, 2022, 8:38am UTC](https://forum.data-community.org/t/why-the-business-key-should-not-reside-in-the-sat/179 "2022-04-07T08:38:00Z")

</div>

Greetings, (on recommendation from @patrickcuba , I am posting this question :slight\_smile: ) What is the main reason we don’t put the Business Keys (not the hashed values) in the SAT? I understand why we don’t put the…

---

## [START\_DATE and END\_DATE in EFF\_SAT macro](https://forum.data-community.org/t/start-date-and-end-date-in-eff-sat-macro/597)

<div class="topic-metadata">

**Author:** [@saqib](https://forum.data-community.org/u/saqib)\
**Replies:** 17\
**Last updated:** [June 6, 2023, 8:00am UTC](https://forum.data-community.org/t/start-date-and-end-date-in-eff-sat-macro/597 "2023-06-06T08:00:34Z")

</div>

Hi Is anyone using the DBT Effectivity SAT macro? I want to understand the pattern for capturing the START\_DATE and END\_DATE when the source doesn’t provide it. We have ORDER\_HK as the driving key. And CUSTOMER\_HK as th…

---

## [How to model website tracking data in DV 2.0](https://forum.data-community.org/t/how-to-model-website-tracking-data-in-dv-2-0/1058)

<div class="topic-metadata">

**Author:** [@mrcol](https://forum.data-community.org/u/mrcol)\
**Replies:** 18\
**Last updated:** [March 2, 2024, 9:31pm UTC](https://forum.data-community.org/t/how-to-model-website-tracking-data-in-dv-2-0/1058 "2024-03-02T21:31:46Z")

</div>

Hello DV Community, I would like to ask what’s the best way, in your opinion, to model website tracking data (e.g. Google Analytics) according to the DV 2.0 standard. The raw (toy) data looks something like this: | vi…

---

## [Creating Multiple Status Tracking Satellites associated to the same hub ](https://forum.data-community.org/t/creating-multiple-status-tracking-satellites-associated-to-the-same-hub/1015)

<div class="topic-metadata">

**Author:** [@pdoortje](https://forum.data-community.org/u/pdoortje)\
**Replies:** 10\
**Last updated:** [November 3, 2023, 11:00am UTC](https://forum.data-community.org/t/creating-multiple-status-tracking-satellites-associated-to-the-same-hub/1015 "2023-11-03T11:00:32Z")

</div>

Hello Data Vault User Group, I have a modelling question and would appreciate your insights and advice. I am currently working on a project involving three source tables : ‘Inquiry’, ‘Inquiry\_characteristic’ and ‘Inqui…

---

## [Query optimization for the Link SAT with Dependent Child](https://forum.data-community.org/t/query-optimization-for-the-link-sat-with-dependent-child/301)

<div class="topic-metadata">

**Author:** [@saqib](https://forum.data-community.org/u/saqib)\
**Replies:** 12\
**Last updated:** [June 7, 2022, 11:20pm UTC](https://forum.data-community.org/t/query-optimization-for-the-link-sat-with-dependent-child/301 "2022-06-07T23:20:04Z")

</div>

Hello all, We have a LINK SAT which has multi-field Dependent Child. These multiple fields grouped, define a single LINE ITEM. Querying this LINK SAT to get the latest record for each line item is extremely slow as we …

---

## [Bridge pseudo code](https://forum.data-community.org/t/bridge-pseudo-code/637)

<div class="topic-metadata">

**Author:** [@FrenkLoonen](https://forum.data-community.org/u/FrenkLoonen)\
**Replies:** 10\
**Last updated:** [September 9, 2024, 8:48am UTC](https://forum.data-community.org/t/bridge-pseudo-code/637 "2024-09-09T08:48:21Z")

</div>

Hi all, I’m looking to implement my first bridge table using dbtvault. I looked up @patrickcuba pseudo code, but unfortunately, that doesn’t cover effectivity satellites. So I have a Hub (called “hub”), with two Links …

---

## [Loading the same HUB as part of two different DBT jobs](https://forum.data-community.org/t/loading-the-same-hub-as-part-of-two-different-dbt-jobs/1085)

<div class="topic-metadata">

**Author:** [@saqib](https://forum.data-community.org/u/saqib)\
**Replies:** 13\
**Last updated:** [December 13, 2023, 11:47pm UTC](https://forum.data-community.org/t/loading-the-same-hub-as-part-of-two-different-dbt-jobs/1085 "2023-12-13T23:47:00Z")

</div>

Hi, We have a HUB\_ORDER that integrates ORDERs from Netsuite and Salesforce. The cadence for new Order data from Salesforce and Netsuite is different. So we have two DBT jobs that load data from these sources into their…

---

## [Zero key as ghost record hash key?](https://forum.data-community.org/t/zero-key-as-ghost-record-hash-key/1103)

<div class="topic-metadata">

**Author:** [@pdoortje](https://forum.data-community.org/u/pdoortje)\
**Replies:** 11\
**Last updated:** [January 22, 2024, 2:17pm UTC](https://forum.data-community.org/t/zero-key-as-ghost-record-hash-key/1103 "2024-01-22T14:17:13Z")

</div>

Hello, If I understand correctly, according to some articles from Scalefree, I should use the hash key of the unknown zero key as the hash key for the ghost record. This approach allows me to perform an EQUI JOIN on an …

---

## [Optimizing SAT Loading from Staging as a VIEW in Snowflake](https://forum.data-community.org/t/optimizing-sat-loading-from-staging-as-a-view-in-snowflake/307)

<div class="topic-metadata">

**Author:** [@saqib](https://forum.data-community.org/u/saqib)\
**Replies:** 15\
**Last updated:** [August 5, 2022, 8:05am UTC](https://forum.data-community.org/t/optimizing-sat-loading-from-staging-as-a-view-in-snowflake/307 "2022-08-05T08:05:24Z")

</div>

Hello all, We have Staging as VIEW. The underlying query producing the Staging VIEW is complex with lot of UNIONs and JOINs and lot of data. However the delta that gets loaded into the SAT in single run is \< 100 records…

---

## [DV modeling with sereval sources and no nice business key](https://forum.data-community.org/t/dv-modeling-with-sereval-sources-and-no-nice-business-key/537)

<div class="topic-metadata">

**Author:** [@ecozturk](https://forum.data-community.org/u/ecozturk)\
**Replies:** 14\
**Last updated:** [January 19, 2023, 8:29am UTC](https://forum.data-community.org/t/dv-modeling-with-sereval-sources-and-no-nice-business-key/537 "2023-01-19T08:29:31Z")

</div>

Hello, I am quite a beginner in DV, but i have sevearl years of XP in dimensional modeling. I have some questions/challenges raised by the DV itself and the new practices that appeared with modern cloud datawarehouses,…

---

## [Two or more dependent children in a LINK?](https://forum.data-community.org/t/two-or-more-dependent-children-in-a-link/185)

<div class="topic-metadata">

**Author:** [@saqib](https://forum.data-community.org/u/saqib)\
**Replies:** 15\
**Last updated:** [March 13, 2022, 10:56pm UTC](https://forum.data-community.org/t/two-or-more-dependent-children-in-a-link/185 "2022-03-13T22:56:19Z")

</div>

Hi all, We have two dependent children (subclass and class) that do not have any meaning by themselves. We are thinking of adding them to the LINK as follows: Question: Is this the correct way to hang two satellites…

---

## [How to design Raw Vault for Ledger Summary and Ledger Line item tables?](https://forum.data-community.org/t/how-to-design-raw-vault-for-ledger-summary-and-ledger-line-item-tables/169)

<div class="topic-metadata">

**Author:** [@spachunuri](https://forum.data-community.org/u/spachunuri)\
**Replies:** 13\
**Last updated:** [February 24, 2022, 2:40am UTC](https://forum.data-community.org/t/how-to-design-raw-vault-for-ledger-summary-and-ledger-line-item-tables/169 "2022-02-24T02:40:30Z")

</div>

Hi Y’all. My name is Sunny. I know there has been a significant discussion on the Data Vault alliance discussion group before, but I would like to bring this discussion up here to get some suggestions from the team. We a…

---

## [What's the best approach for removing columns from a satellite?](https://forum.data-community.org/t/whats-the-best-approach-for-removing-columns-from-a-satellite/1788)

<div class="topic-metadata">

**Author:** [@Frankie](https://forum.data-community.org/u/Frankie)\
**Replies:** 17\
**Last updated:** [August 8, 2025, 11:34am UTC](https://forum.data-community.org/t/whats-the-best-approach-for-removing-columns-from-a-satellite/1788 "2025-08-08T11:34:58Z")

</div>

Hi All, We’ve done some plugging away at our DV tech debt recently and found that there’s a metadata column that we would like to remove from a satellite, It’s not breaking anything to keep around but it’s rapidly chang…

---

## [Modelling Question on Business Key Updating in source system](https://forum.data-community.org/t/modelling-question-on-business-key-updating-in-source-system/385)

<div class="topic-metadata">

**Author:** [@preddy](https://forum.data-community.org/u/preddy)\
**Replies:** 9\
**Last updated:** [September 19, 2022, 10:07pm UTC](https://forum.data-community.org/t/modelling-question-on-business-key-updating-in-source-system/385 "2022-09-19T22:07:26Z")

</div>

Hi, we are beginning to implementing DV2. Need advice on how to deal with below scenario In source system we have surrogate key and Business key, There are some situations where Business key is updated in source syste…

---

## [Modeling question on Child Key on Data Vault 2.0](https://forum.data-community.org/t/modeling-question-on-child-key-on-data-vault-2-0/875)

<div class="topic-metadata">

**Author:** [@rudra](https://forum.data-community.org/u/rudra)\
**Replies:** 11\
**Last updated:** [July 6, 2023, 4:07pm UTC](https://forum.data-community.org/t/modeling-question-on-child-key-on-data-vault-2-0/875 "2023-07-06T16:07:24Z")

</div>

Hello All, Can you please share your thoughts about dependent key and modeling question in DV 2.0 We have source table about customer and address details. One customer can have multiple addresses. Background informati…

---

## [naming and splitting satellite tables](https://forum.data-community.org/t/naming-and-splitting-satellite-tables/1297)

<div class="topic-metadata">

**Author:** [@mabrouk.gadri](https://forum.data-community.org/u/mabrouk.gadri)\
**Replies:** 11\
**Last updated:** [May 11, 2024, 1:31pm UTC](https://forum.data-community.org/t/naming-and-splitting-satellite-tables/1297 "2024-05-11T13:31:06Z")

</div>

Hi, what’s the most popular approach to naming satellites when there are frequent schema changes in the source ? I am thinking about the scenario where have a sat\_customer table coming from the CRM, then new columns ar…

---

## [Questions regarding applied timestamp](https://forum.data-community.org/t/questions-regarding-applied-timestamp/2010)

<div class="topic-metadata">

**Author:** [@JLeicht](https://forum.data-community.org/u/JLeicht)\
**Replies:** 12\
**Last updated:** [February 5, 2026, 8:55am UTC](https://forum.data-community.org/t/questions-regarding-applied-timestamp/2010 "2026-02-05T08:55:27Z")

</div>

Hello everyone I have some questions related to the applied timestamp metadata field. There is not much information about the optional applied timestamp. I think the most detailed explanation is found in the excellent …

---

## [Alternative for MSAT containing very big sets](https://forum.data-community.org/t/alternative-for-msat-containing-very-big-sets/474)

<div class="topic-metadata">

**Author:** [@FrenkLoonen](https://forum.data-community.org/u/FrenkLoonen)\
**Replies:** 12\
**Last updated:** [November 4, 2023, 9:03am UTC](https://forum.data-community.org/t/alternative-for-msat-containing-very-big-sets/474 "2023-11-04T09:03:17Z")

</div>

I’ve got a modelling challenge. I have to model account limits. My source file contains (in its simple form): AccountNumber, LimitDate, LimitAmount The PK is AccountNumber+LimitDate. Basically, it’s telling me per Acc…

[Next page](https://forum.data-community.org/top.md?page=1&per_page=50)
