# Top

**URL:** https://forum.data-community.org/top.md?page=1

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

**Page:** 2

---

## [Advice for satellite with dependent child keys and hard deletions from source](https://forum.data-community.org/t/advice-for-satellite-with-dependent-child-keys-and-hard-deletions-from-source/1200)

<div class="topic-metadata">

**Author:** [@tdean](https://forum.data-community.org/u/tdean)\
**Replies:** 9\
**Last updated:** [March 11, 2024, 11:05am UTC](https://forum.data-community.org/t/advice-for-satellite-with-dependent-child-keys-and-hard-deletions-from-source/1200 "2024-03-11T11:05:01Z")

</div>

Hi, I have a scenario that I’m struggle to model correctly adhering to the DV 2.0 specification. We have a business concept of a Patient that has an identifier that can be used as the business key. At the moment we…

---

## [Renaming the source columns in raw vault](https://forum.data-community.org/t/renaming-the-source-columns-in-raw-vault/1311)

<div class="topic-metadata">

**Author:** [@mrcool4](https://forum.data-community.org/u/mrcool4)\
**Replies:** 10\
**Last updated:** [February 23, 2025, 9:52pm UTC](https://forum.data-community.org/t/renaming-the-source-columns-in-raw-vault/1311 "2025-02-23T21:52:59Z")

</div>

Hi All, We have encountered a few special column names that are reserved words(keywords), and numeric column names like 238567 from the source tables. What is the best practice for handling these columns in the raw vaul…

---

## [Where to store source system technical keys?](https://forum.data-community.org/t/where-to-store-source-system-technical-keys/774)

<div class="topic-metadata">

**Author:** [@Nat](https://forum.data-community.org/u/Nat)\
**Replies:** 10\
**Last updated:** [June 14, 2023, 6:55am UTC](https://forum.data-community.org/t/where-to-store-source-system-technical-keys/774 "2023-06-14T06:55:56Z")

</div>

Should source system technical keys be stored in the relevant satellite? Obviously the hub should contain the business key, but would you also store the technical key as an attribute in the satellite for reference back …

---

## [Virtualised dimensions](https://forum.data-community.org/t/virtualised-dimensions/287)

<div class="topic-metadata">

**Author:** [@jhall\_uk](https://forum.data-community.org/u/jhall_uk)\
**Replies:** 9\
**Last updated:** [May 26, 2022, 9:25pm UTC](https://forum.data-community.org/t/virtualised-dimensions/287 "2022-05-26T21:25:29Z")

</div>

Greetings all, I’m looking at virtualising the information mart layer for the first time from the persisted data vault layer and have a question around dimensions. The examples I have seen in Dan’s book focus on dimensi…

---

## [Data Vault Modeling: Storing Role Type – Satellite or Hub?](https://forum.data-community.org/t/data-vault-modeling-storing-role-type-satellite-or-hub/1489)

<div class="topic-metadata">

**Author:** [@tg3](https://forum.data-community.org/u/tg3)\
**Replies:** 12\
**Last updated:** [October 13, 2024, 10:09pm UTC](https://forum.data-community.org/t/data-vault-modeling-storing-role-type-satellite-or-hub/1489 "2024-10-13T22:09:18Z")

</div>

Hi everyone, I’m new to this forum and relatively new to Data Vault modeling and data warehousing. I’m working on a project and would love some guidance from the experts here. Context: I have an Employee Hub that sto…

---

## [Business Key treatments: what is allowed and what isn't?](https://forum.data-community.org/t/business-key-treatments-what-is-allowed-and-what-isnt/379)

<div class="topic-metadata">

**Author:** [@FrenkLoonen](https://forum.data-community.org/u/FrenkLoonen)\
**Replies:** 10\
**Last updated:** [August 21, 2022, 11:12pm UTC](https://forum.data-community.org/t/business-key-treatments-what-is-allowed-and-what-isnt/379 "2022-08-21T23:12:56Z")

</div>

I have several sources that all deliver references to a local client. There’s even one source that is now considered the golden source wrt client data, in which they’ve brought all client data from all local systems toge…

---

## [Filtering content of the source - hard rule?](https://forum.data-community.org/t/filtering-content-of-the-source-hard-rule/762)

<div class="topic-metadata">

**Author:** [@DVBeginner](https://forum.data-community.org/u/DVBeginner)\
**Replies:** 10\
**Last updated:** [May 16, 2023, 8:08pm UTC](https://forum.data-community.org/t/filtering-content-of-the-source-hard-rule/762 "2023-05-16T20:08:34Z")

</div>

Hi I have a question regarding placing of the data filtering logic. There is an interface that mixes data for different concepts (e.g. entries for offer and contract). Is it a best practice to filter subsets when load…

---

## [Attribute in Satelite tables vs plain Link tables](https://forum.data-community.org/t/attribute-in-satelite-tables-vs-plain-link-tables/1206)

<div class="topic-metadata">

**Author:** [@Schorsch73](https://forum.data-community.org/u/Schorsch73)\
**Replies:** 9\
**Last updated:** [May 7, 2024, 6:04am UTC](https://forum.data-community.org/t/attribute-in-satelite-tables-vs-plain-link-tables/1206 "2024-05-07T06:04:16Z")

</div>

Hi we are pretty new to data vault and currently doing some first steps. A question that came up was about if there are any best practices when it comes to Sat-Links When I have lets say a transaction hub and an emplo…

---

## [Losing leading zeros in business key](https://forum.data-community.org/t/losing-leading-zeros-in-business-key/82)

<div class="topic-metadata">

**Author:** [@joe.barter](https://forum.data-community.org/u/joe.barter)\
**Replies:** 9\
**Last updated:** [May 16, 2022, 6:44am UTC](https://forum.data-community.org/t/losing-leading-zeros-in-business-key/82 "2022-05-16T06:44:59Z")

</div>

(Hi all, I added this question for information and discussion purposes as it is a common topic in our projects) I have an integer column which is a business key which requires leading zeros in the key. However, these ar…

---

## [When insert in parent table?](https://forum.data-community.org/t/when-insert-in-parent-table/328)

<div class="topic-metadata">

**Author:** [@Arthur](https://forum.data-community.org/u/Arthur)\
**Replies:** 10\
**Last updated:** [June 16, 2022, 4:53pm UTC](https://forum.data-community.org/t/when-insert-in-parent-table/328 "2022-06-16T16:53:07Z")

</div>

Hello, We can read concerning link loading in The Data Vault Guru that: Has the staged source file of the link table been used to supply content to parent hub tables? Yes Should we understand that when a link is in…

---

## [Loading of Hub's and Links](https://forum.data-community.org/t/loading-of-hubs-and-links/322)

<div class="topic-metadata">

**Author:** [@Bigguy365](https://forum.data-community.org/u/Bigguy365)\
**Replies:** 9\
**Last updated:** [June 14, 2022, 3:54pm UTC](https://forum.data-community.org/t/loading-of-hubs-and-links/322 "2022-06-14T15:54:18Z")

</div>

We have a reasonably disciplined shop where consistency exists within various applications when referencing an employee. For example, we have four applications that all use the same key value that identifies the employee…

---

## [Staging treated/untreated business keys](https://forum.data-community.org/t/staging-treated-untreated-business-keys/211)

<div class="topic-metadata">

**Author:** [@jhall\_uk](https://forum.data-community.org/u/jhall_uk)\
**Replies:** 9\
**Last updated:** [April 18, 2022, 11:03pm UTC](https://forum.data-community.org/t/staging-treated-untreated-business-keys/211 "2022-04-18T23:03:11Z")

</div>

Hi everyone, I have a question about whether people currently persist (if at all) both the untreated and treated business key in the staging table before loading into the target hub. It is good practice to hold the raw …

---

## [How to model repeating IoT data](https://forum.data-community.org/t/how-to-model-repeating-iot-data/790)

<div class="topic-metadata">

**Author:** [@sosmaf](https://forum.data-community.org/u/sosmaf)\
**Replies:** 9\
**Last updated:** [May 15, 2023, 7:47am UTC](https://forum.data-community.org/t/how-to-model-repeating-iot-data/790 "2023-05-15T07:47:35Z")

</div>

Hey, How to correctly model IoT data which rows cannot be uniquely identified and cannot detect delta? We have rows which are 100% identical, we have otherwise identical rows but one value changing and we have unide…

---

## [Link and the inlcusion or exclusion of a BK](https://forum.data-community.org/t/link-and-the-inlcusion-or-exclusion-of-a-bk/2045)

<div class="topic-metadata">

**Author:** [@jsteinbeck](https://forum.data-community.org/u/jsteinbeck)\
**Replies:** 11\
**Last updated:** [March 9, 2026, 9:55am UTC](https://forum.data-community.org/t/link-and-the-inlcusion-or-exclusion-of-a-bk/2045 "2026-03-09T09:55:18Z")

</div>

Hi, Quick question: If I have a file/table that will be a link and I have 3 BKs, which will be hashed, that is a given, and these 3 BKs will provide the grain for unique record counts. If, however, I have other known B…

---

## [Domain vs sub-domains](https://forum.data-community.org/t/domain-vs-sub-domains/1330)

<div class="topic-metadata">

**Author:** [@Datavault4u](https://forum.data-community.org/u/Datavault4u)\
**Replies:** 13\
**Last updated:** [June 17, 2024, 6:51am UTC](https://forum.data-community.org/t/domain-vs-sub-domains/1330 "2024-06-17T06:51:06Z")

</div>

All, I would classify ‘store’ as a sub-domain of site. As Site also includes our warehouses (RSC Retail Service Centre) and CFCs (Customer Fulfillment Centres) that support on-line activities as well there are our offic…

---

## [PII data for Business Keys](https://forum.data-community.org/t/pii-data-for-business-keys/488)

<div class="topic-metadata">

**Author:** [@FrenkLoonen](https://forum.data-community.org/u/FrenkLoonen)\
**Replies:** 10\
**Last updated:** [November 9, 2022, 5:08pm UTC](https://forum.data-community.org/t/pii-data-for-business-keys/488 "2022-11-09T17:08:20Z")

</div>

Another day, another challenge. I have my h\_party with its BK being party\_id, sourced from our golden source (let’s call that source GS) table Party, column PartyId. Now, I need to load external credit ratings coming f…

---

## [Split or consolidate hubs?](https://forum.data-community.org/t/split-or-consolidate-hubs/1427)

<div class="topic-metadata">

**Author:** [@MarkyMark](https://forum.data-community.org/u/MarkyMark)\
**Replies:** 9\
**Last updated:** [September 25, 2024, 8:22am UTC](https://forum.data-community.org/t/split-or-consolidate-hubs/1427 "2024-09-25T08:22:40Z")

</div>

I have four source systems describing target individuals who work for target organisations. The context is selling or promoting healthcare products and services to private and public healthcare services. Source 1 entiti…

---

## [Modeling Firebase app logs](https://forum.data-community.org/t/modeling-firebase-app-logs/1907)

<div class="topic-metadata">

**Author:** [@saqib](https://forum.data-community.org/u/saqib)\
**Replies:** 9\
**Last updated:** [July 19, 2025, 9:26pm UTC](https://forum.data-community.org/t/modeling-firebase-app-logs/1907 "2025-07-19T21:26:48Z")

</div>

We working on modeling out Android App Logs. Android Apps can be used across multiple devices by the same user. We have hub\_app, hub\_user and hub\_screen\_id. screen\_id is a unique ID of the screen which was opened by the…

---

## [Welcome to the Data Vault User Group Discourse](https://forum.data-community.org/t/welcome-to-the-data-vault-user-group-discourse/7)

<div class="topic-metadata">

**Author:** [@system](https://forum.data-community.org/u/system)\
**Replies:** 0\
**Last updated:** [November 23, 2021, 3:10pm UTC](https://forum.data-community.org/t/welcome-to-the-data-vault-user-group-discourse/7 "2021-11-23T15:10:42Z")

</div>

Our Data Vault User Group is an open independent community of data professionals committed to sharing knowledge and experience of building data platforms (warehouses, lakes, hubs) using the Data Vault method, or any cont…

---

## [Advent Calendar](https://forum.data-community.org/t/advent-calendar/90)

<div class="topic-metadata">

**Author:** [@patrickcuba](https://forum.data-community.org/u/patrickcuba)\
**Replies:** 1\
**Last updated:** [October 31, 2022, 8:30am UTC](https://forum.data-community.org/t/advent-calendar/90 "2022-10-31T08:30:51Z")

</div>

Happy New Year all, For awareness I did a 25 part post on Data Vault and some common and uncommon Christmas related traditions. Enjoy! In case you missed it, the #datavault advent calendar was published last month! B…

---

## [How to design data vault in case of multiple source systems and many satellites for each source](https://forum.data-community.org/t/how-to-design-data-vault-in-case-of-multiple-source-systems-and-many-satellites-for-each-source/573)

<div class="topic-metadata">

**Author:** [@Chandra](https://forum.data-community.org/u/Chandra)\
**Replies:** 3\
**Last updated:** [February 5, 2023, 9:47pm UTC](https://forum.data-community.org/t/how-to-design-data-vault-in-case-of-multiple-source-systems-and-many-satellites-for-each-source/573 "2023-02-05T21:47:10Z")

</div>

Hi, I have Implemented data vault for single source system using dbtvault on Big query. Now I have a use case where data is coming from multiple source systems(3 to 4) for one data product and most of the attributes are…

---

## [Deleted Records Detection](https://forum.data-community.org/t/deleted-records-detection/400)

<div class="topic-metadata">

**Author:** [@kvs.naidu](https://forum.data-community.org/u/kvs.naidu)\
**Replies:** 4\
**Last updated:** [August 25, 2022, 12:12am UTC](https://forum.data-community.org/t/deleted-records-detection/400 "2022-08-25T00:12:29Z")

</div>

How data vault detects deleted records in ? Suppose there is a records in source system with bkey vaule 101 and descriptive data. In 1st load this record loaded into data vault tables(Hub,link and sat). After that load …

---

## [Primary Keys on Information Marts](https://forum.data-community.org/t/primary-keys-on-information-marts/994)

<div class="topic-metadata">

**Author:** [@sicarul](https://forum.data-community.org/u/sicarul)\
**Replies:** 8\
**Last updated:** [October 23, 2023, 12:55am UTC](https://forum.data-community.org/t/primary-keys-on-information-marts/994 "2023-10-23T00:55:21Z")

</div>

Hey folks! I’ve been pondering about this for some days, and i was wondering about this: When building the information marts, as Kimball-style marts (dimensions and fact tables) - Do you use the hash keys as your keys t…

---

## [Insert Only Effectivity Satellites](https://forum.data-community.org/t/insert-only-effectivity-satellites/902)

<div class="topic-metadata">

**Author:** [@jmamedov](https://forum.data-community.org/u/jmamedov)\
**Replies:** 5\
**Last updated:** [February 28, 2024, 9:25am UTC](https://forum.data-community.org/t/insert-only-effectivity-satellites/902 "2024-02-28T09:25:07Z")

</div>

I cannot find any refence about how you can close (end effectivity) of a previous record without updating it in effectivity satellite table. I could not find any example or explanation in Patrick Cuba’s book “The Data Va…

---

## [Varying Business Keys](https://forum.data-community.org/t/varying-business-keys/506)

<div class="topic-metadata">

**Author:** [@Kthomason420](https://forum.data-community.org/u/Kthomason420)\
**Replies:** 4\
**Last updated:** [December 2, 2022, 10:06am UTC](https://forum.data-community.org/t/varying-business-keys/506 "2022-12-02T10:06:43Z")

</div>

I’m working on a healthcare project that is specifically exx\\posing data quality issues with Providers.The problem is, I’m working with 5 systems and they don’t have consistent business keys. Example: For EPIC, most, b…

---

## [Business Key Field Names from Different Sources with the \*Same\* Values - Is it still passive integration?](https://forum.data-community.org/t/business-key-field-names-from-different-sources-with-the-same-values-is-it-still-passive-integration/114)

<div class="topic-metadata">

**Author:** [@Nicruzer](https://forum.data-community.org/u/Nicruzer)\
**Replies:** 6\
**Last updated:** [February 3, 2022, 11:15am UTC](https://forum.data-community.org/t/business-key-field-names-from-different-sources-with-the-same-values-is-it-still-passive-integration/114 "2022-02-03T11:15:02Z")

</div>

We currently have a situation where 3 different sources provide the same business key (and value) with 3 different source field names. The “master key” in this case is called EmployeeId. The other two sources come from A…

---

## [AutomateDV vs dataVault4dbt](https://forum.data-community.org/t/automatedv-vs-datavault4dbt/1393)

<div class="topic-metadata">

**Author:** [@kasia](https://forum.data-community.org/u/kasia)\
**Replies:** 8\
**Last updated:** [July 23, 2024, 6:18pm UTC](https://forum.data-community.org/t/automatedv-vs-datavault4dbt/1393 "2024-07-23T18:18:57Z")

</div>

Dear Data-Vaulters, I’m about to choose which data vault package for dbt will be used in my company. Do you have experiences with automateDV and/or datavault4dbt? Which one is better? To make things more complex on my …

---

## [Hash key generation - sequence of columns](https://forum.data-community.org/t/hash-key-generation-sequence-of-columns/633)

<div class="topic-metadata">

**Author:** [@Nikunj](https://forum.data-community.org/u/Nikunj)\
**Replies:** 3\
**Last updated:** [March 7, 2023, 11:27am UTC](https://forum.data-community.org/t/hash-key-generation-sequence-of-columns/633 "2023-03-07T11:27:38Z")

</div>

For Hub table hash key generation, we have BKCC (business key collision code) + Employee\_Id For the Satellite Table defined as, name + phone\_no + gender + email\_id If I take the columns of the satellite table which w…

---

## [Which is the best model to create Information mart on Raw data vault in Big query](https://forum.data-community.org/t/which-is-the-best-model-to-create-information-mart-on-raw-data-vault-in-big-query/581)

<div class="topic-metadata">

**Author:** [@Chandra](https://forum.data-community.org/u/Chandra)\
**Replies:** 6\
**Last updated:** [February 23, 2023, 8:39am UTC](https://forum.data-community.org/t/which-is-the-best-model-to-create-information-mart-on-raw-data-vault-in-big-query/581 "2023-02-23T08:39:07Z")

</div>

Hi, I am working on data vault, we are using DBT and Big query. As of now we have created raw data vault on Big query using dbt templates and we are working on creating information mart on top of it. So which is the b…

---

## [Initial Loading of Link Tables from Staging](https://forum.data-community.org/t/initial-loading-of-link-tables-from-staging/459)

<div class="topic-metadata">

**Author:** [@Bigguy365](https://forum.data-community.org/u/Bigguy365)\
**Replies:** 8\
**Last updated:** [April 24, 2024, 12:50pm UTC](https://forum.data-community.org/t/initial-loading-of-link-tables-from-staging/459 "2024-04-24T12:50:24Z")

</div>

I’m requesting clarification on the topic in your book dealing with the loading of link tables in the Automation and Orchestration chapter. Your diagram indicates a dependency exists before the link table is created.…

---

## [Same-As Link Advice](https://forum.data-community.org/t/same-as-link-advice/622)

<div class="topic-metadata">

**Author:** [@justin](https://forum.data-community.org/u/justin)\
**Replies:** 6\
**Last updated:** [February 21, 2023, 10:16pm UTC](https://forum.data-community.org/t/same-as-link-advice/622 "2023-02-21T22:16:02Z")

</div>

I have two raw source files that contain the relationship between a customer\_id and its various IDs from other systems. The first file has our old, internal customer\_id along with a third party vendor ID we’ll call ven1…

---

## [Using external load-dates](https://forum.data-community.org/t/using-external-load-dates/27)

<div class="topic-metadata">

**Author:** [@john.frost](https://forum.data-community.org/u/john.frost)\
**Replies:** 4\
**Last updated:** [January 28, 2022, 4:26pm UTC](https://forum.data-community.org/t/using-external-load-dates/27 "2022-01-28T16:26:28Z")

</div>

Hi all, I’m trying to load historical data in to a data vault warehouse, and we’re considering using a source-system effective-from date as a load date. How could I go about this without breaking the load patterns?

---

## [DeNormalizing/Flattening Raw vault entities to create Dimensions for the Information Mart](https://forum.data-community.org/t/denormalizing-flattening-raw-vault-entities-to-create-dimensions-for-the-information-mart/870)

<div class="topic-metadata">

**Author:** [@Irfan](https://forum.data-community.org/u/Irfan)\
**Replies:** 3\
**Last updated:** [June 29, 2023, 2:04pm UTC](https://forum.data-community.org/t/denormalizing-flattening-raw-vault-entities-to-create-dimensions-for-the-information-mart/870 "2023-06-29T14:04:16Z")

</div>

I want to ask what is the best way to create Information Mart dimensions when more hubs (and Satellites) are participating in creating a DeNormalized Dimension. For e.g., Let’s say there is a Product Hub that has an ind…

---

## [Filtering a source table/file when loading Raw Data Vault](https://forum.data-community.org/t/filtering-a-source-table-file-when-loading-raw-data-vault/377)

<div class="topic-metadata">

**Author:** [@FrenkLoonen](https://forum.data-community.org/u/FrenkLoonen)\
**Replies:** 7\
**Last updated:** [January 15, 2024, 8:38am UTC](https://forum.data-community.org/t/filtering-a-source-table-file-when-loading-raw-data-vault/377 "2024-01-15T08:38:39Z")

</div>

What are everyone’s thoughts on filtering the source data when loading the Raw Data Vault (provided that you still load all the data)? Note: going back to the source and have them deliver the data in a different way is n…

---

## [What are the drawbacks of SAT-to-SAT joins? ](https://forum.data-community.org/t/what-are-the-drawbacks-of-sat-to-sat-joins/889)

<div class="topic-metadata">

**Author:** [@dv\_user](https://forum.data-community.org/u/dv_user)\
**Replies:** 5\
**Last updated:** [July 13, 2023, 6:40pm UTC](https://forum.data-community.org/t/what-are-the-drawbacks-of-sat-to-sat-joins/889 "2023-07-13T18:40:06Z")

</div>

Hi Amazing folks, I am new to this community and trying to understand the concepts of DV. I am not able to figure out a concept of why we should not join a SAT to SAT(BK to BK join) table and should always traverse thro…

---

## [Implementing DV without an automation tool](https://forum.data-community.org/t/implementing-dv-without-an-automation-tool/106)

<div class="topic-metadata">

**Author:** [@anon83229795](https://forum.data-community.org/u/anon83229795)\
**Replies:** 4\
**Last updated:** [January 28, 2022, 2:36am UTC](https://forum.data-community.org/t/implementing-dv-without-an-automation-tool/106 "2022-01-28T02:36:08Z")

</div>

Implementing DV seems quite a big and complex effort. So we currently think - without an Automation Tool (e.g. DataVault Builder, WhereScape etc.) the implementation is quite hard. What’s your opinion? (This is one of t…

---

## [What is the rationale for not loading links containing NULL values in dbtvault?](https://forum.data-community.org/t/what-is-the-rationale-for-not-loading-links-containing-null-values-in-dbtvault/286)

<div class="topic-metadata">

**Author:** [@peepkungas](https://forum.data-community.org/u/peepkungas)\
**Replies:** 1\
**Last updated:** [May 20, 2022, 12:19pm UTC](https://forum.data-community.org/t/what-is-the-rationale-for-not-loading-links-containing-null-values-in-dbtvault/286 "2022-05-20T12:19:49Z")

</div>

We are implementing link tables, which refer to multiple hubs. dbtvault’s best practice is that “If the primary or ANY of the foreign keys is null, then the record does not get loaded” (Best Practices - dbtvault ). At th…

---

## [Raw Vault layer data modeling questions ](https://forum.data-community.org/t/raw-vault-layer-data-modeling-questions/282)

<div class="topic-metadata">

**Author:** [@DataGuru](https://forum.data-community.org/u/DataGuru)\
**Replies:** 7\
**Last updated:** [May 24, 2022, 11:49pm UTC](https://forum.data-community.org/t/raw-vault-layer-data-modeling-questions/282 "2022-05-24T23:49:42Z")

</div>

Hello All, We are doing a POC to refactor our data assets using DV 2.0 methodology and having a few questions about RV layer. Why do we need record\_source column in Satellite tables if they are already source specific…

---

## [Hierarchy in Dependent Child](https://forum.data-community.org/t/hierarchy-in-dependent-child/200)

<div class="topic-metadata">

**Author:** [@saqib](https://forum.data-community.org/u/saqib)\
**Replies:** 6\
**Last updated:** [March 15, 2022, 1:38pm UTC](https://forum.data-community.org/t/hierarchy-in-dependent-child/200 "2022-03-15T13:38:08Z")

</div>

Hi. We have hierarchy in the Line Item level (Dependent Child). How do we model that hierarchy? Here is what the ORDER and ODER\_LINE look like. ORDER\_HEADER: ORDER\_HEADER\_KEY ORDER\_NO TOTAL\_AMOUNT SHIP\_TO BILL\_TO …

---

## [Source Tables - joining transactional tables or not?](https://forum.data-community.org/t/source-tables-joining-transactional-tables-or-not/699)

<div class="topic-metadata">

**Author:** [@andy](https://forum.data-community.org/u/andy)\
**Replies:** 7\
**Last updated:** [March 19, 2023, 11:03pm UTC](https://forum.data-community.org/t/source-tables-joining-transactional-tables-or-not/699 "2023-03-19T23:03:52Z")

</div>

Hi all, I’ve been doing more reading. I think my confusion is stemming from the relatively little information that exists on how to model your data before feeding into data vault. In that context, I’m hoping to ask a fe…

---

## [What is a Source Data Vault?](https://forum.data-community.org/t/what-is-a-source-data-vault/262)

<div class="topic-metadata">

**Author:** [@klausb](https://forum.data-community.org/u/klausb)\
**Replies:** 7\
**Last updated:** [May 16, 2022, 7:28am UTC](https://forum.data-community.org/t/what-is-a-source-data-vault/262 "2022-05-16T07:28:59Z")

</div>

Hi communty, you can read it in several posts all over the internet. Don’t build a Source Data Vault! I wonder if there is a definition for a Source DV? I would assume this term comes from the idea of building Busines…

---

## [Data Vault with Databricks](https://forum.data-community.org/t/data-vault-with-databricks/701)

<div class="topic-metadata">

**Author:** [@jhall\_uk](https://forum.data-community.org/u/jhall_uk)\
**Replies:** 6\
**Last updated:** [June 19, 2023, 2:47pm UTC](https://forum.data-community.org/t/data-vault-with-databricks/701 "2023-06-19T14:47:57Z")

</div>

Greetings all! Has anyone got any practical experience of using Data Vault against an (Azure) Databricks platform. Is there any general guidance on how well this works? I’m trying to figure out if it is “better” to onl…

---

## [Storing the start and end date for a link in effectivity satellite or "plain" satellite](https://forum.data-community.org/t/storing-the-start-and-end-date-for-a-link-in-effectivity-satellite-or-plain-satellite/949)

<div class="topic-metadata">

**Author:** [@cschwantes](https://forum.data-community.org/u/cschwantes)\
**Replies:** 4\
**Last updated:** [September 10, 2023, 1:04pm UTC](https://forum.data-community.org/t/storing-the-start-and-end-date-for-a-link-in-effectivity-satellite-or-plain-satellite/949 "2023-09-10T13:04:17Z")

</div>

I am currently modelling data vault 2.0 tables for one of our sources and I’m a bit stuck when it comes to handle validity dates. What the source delivers us, is the relationship between persons and certificates. Each p…

---

## [Link tables with technical key](https://forum.data-community.org/t/link-tables-with-technical-key/734)

<div class="topic-metadata">

**Author:** [@corinaH](https://forum.data-community.org/u/corinaH)\
**Replies:** 6\
**Last updated:** [March 20, 2024, 7:21pm UTC](https://forum.data-community.org/t/link-tables-with-technical-key/734 "2024-03-20T19:21:35Z")

</div>

Hi, we are facing the problem that our source system is submitting a technical id and a human readable id which we are using as the BK. Now the relations between different Hubs coming from our source systems are only pr…

---

## [Hubs using multiple columns as natural identifier - general names or multiple hubs ?](https://forum.data-community.org/t/hubs-using-multiple-columns-as-natural-identifier-general-names-or-multiple-hubs/723)

<div class="topic-metadata">

**Author:** [@mat](https://forum.data-community.org/u/mat)\
**Replies:** 7\
**Last updated:** [April 16, 2023, 10:13pm UTC](https://forum.data-community.org/t/hubs-using-multiple-columns-as-natural-identifier-general-names-or-multiple-hubs/723 "2023-04-16T22:13:58Z")

</div>

Hi everybody! I need some advice regarding best practices in hub column naming convention - especially for multiple columns representing a business key. My project situation: I have source tables providing business ke…

---

## [Two different source table with same columns, can I load to same satellite or different satellite](https://forum.data-community.org/t/two-different-source-table-with-same-columns-can-i-load-to-same-satellite-or-different-satellite/469)

<div class="topic-metadata">

**Author:** [@Nithi](https://forum.data-community.org/u/Nithi)\
**Replies:** 7\
**Last updated:** [October 25, 2022, 10:21pm UTC](https://forum.data-community.org/t/two-different-source-table-with-same-columns-can-i-load-to-same-satellite-or-different-satellite/469 "2022-10-25T22:21:35Z")

</div>

Hi , let say I have two source tables agents\_tx and agents\_ny from same source systems . They have same exact columns, just two different tables because of the way the source system loads data. Would you recommend loadin…

---

## [Modeling of link: reference a hub by businessKey instead of hashKey](https://forum.data-community.org/t/modeling-of-link-reference-a-hub-by-businesskey-instead-of-hashkey/1869)

<div class="topic-metadata">

**Author:** [@julesKr](https://forum.data-community.org/u/julesKr)\
**Replies:** 6\
**Last updated:** [June 30, 2025, 11:48am UTC](https://forum.data-community.org/t/modeling-of-link-reference-a-hub-by-businesskey-instead-of-hashkey/1869 "2025-06-30T11:48:46Z")

</div>

I have a hub (hub\_entity1) with 2 businessKeys and a hashKey which is composed of them. I want to reference this hub by a link table , but I want to reference only the businessKey (so a whole set of rows) instead of the…

---

## [What happened to "Data Modeling Specification v 2.0.2"](https://forum.data-community.org/t/what-happened-to-data-modeling-specification-v-2-0-2/436)

<div class="topic-metadata">

**Author:** [@mrcol](https://forum.data-community.org/u/mrcol)\
**Replies:** 1\
**Last updated:** [September 20, 2022, 1:56pm UTC](https://forum.data-community.org/t/what-happened-to-data-modeling-specification-v-2-0-2/436 "2022-09-20T13:56:00Z")

</div>

Hello everyone, Do you know what happened to the “Data Vault Data Modeling Specification v 2.0.2” that used to be available at https://danlinstedt.com/wp-content/uploads/2018/06/DVModelingSpecs2-0-1.pdf Was it replaced…

---

## [Banking Data Model](https://forum.data-community.org/t/banking-data-model/730)

<div class="topic-metadata">

**Author:** [@shubhankarsharma](https://forum.data-community.org/u/shubhankarsharma)\
**Replies:** 4\
**Last updated:** [April 16, 2023, 10:25pm UTC](https://forum.data-community.org/t/banking-data-model/730 "2023-04-16T22:25:34Z")

</div>

Hello Group, Thank you for some great discussion. I am trying to build a DV2.0 based on a bank domain. Business Entities :slight\_smile: Customer Account : Account is further broken into following sub-types a. Saving…

---

## [Non-historized satellite On Link or Hub](https://forum.data-community.org/t/non-historized-satellite-on-link-or-hub/607)

<div class="topic-metadata">

**Author:** [@Nikunj](https://forum.data-community.org/u/Nikunj)\
**Replies:** 3\
**Last updated:** [July 31, 2023, 10:59am UTC](https://forum.data-community.org/t/non-historized-satellite-on-link-or-hub/607 "2023-07-31T10:59:54Z")

</div>

Hello Everyone, I have been reading about Non-historized Links which are mostly used to meet use-cases where we get immutable data events such as data from IOT, sensor etc. I see a mention of Non-historized satellite i…

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

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