# Data Vault 2.0 **URL:** https://forum.data-community.org/c/datavault-2-0/5.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 --- ## [Entity attributes with attributes](https://forum.data-community.org/t/entity-attributes-with-attributes/1929)
**Author:** [@AlPetMaggioli](https://forum.data-community.org/u/AlPetMaggioli)\ **Replies:** 2\ **Last updated:** [August 18, 2025, 6:35am UTC](https://forum.data-community.org/t/entity-attributes-with-attributes/1929 "2025-08-18T06:35:46Z")
Hello everyone, I am new to data engineering and data vault so I need help for the use case I have stumbled upon. Let’s say that I have a business entity A that has been modeled as a hub. To each record of the entity A… --- ## [Why are hubs, links and satellites separate tables?](https://forum.data-community.org/t/why-are-hubs-links-and-satellites-separate-tables/1746)
**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")
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… --- ## [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)
**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")
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… --- ## [Tracking deletes on a link satellite with a dependent child key](https://forum.data-community.org/t/tracking-deletes-on-a-link-satellite-with-a-dependent-child-key/1910)
**Author:** [@mabrouk.gadri](https://forum.data-community.org/u/mabrouk.gadri)\ **Replies:** 3\ **Last updated:** [July 28, 2025, 4:57am UTC](https://forum.data-community.org/t/tracking-deletes-on-a-link-satellite-with-a-dependent-child-key/1910 "2025-07-28T04:57:41Z")
Is there a recommended approach to track deleted records on a link satellite with a dependent child key ? As an example, an investment is placed by a fund into another fund. The investment is represented by a link betw… --- ## [Transactional Link for capturing Customer Signature upon receive of the product](https://forum.data-community.org/t/transactional-link-for-capturing-customer-signature-upon-receive-of-the-product/1909)
**Author:** [@saqib](https://forum.data-community.org/u/saqib)\ **Replies:** 2\ **Last updated:** [July 27, 2025, 5:06pm UTC](https://forum.data-community.org/t/transactional-link-for-capturing-customer-signature-upon-receive-of-the-product/1909 "2025-07-27T17:06:11Z")
We have a LINK to capture the ORDER and PRODUCT for a Orders: LINK\_ORDER\_PRODUCT with HK\_LINK\_PRODUCT Now we want to capture the Signature data from the Customer when they receive the PRODUCT. The product may be shipped… --- ## [Computation in DataVault](https://forum.data-community.org/t/computation-in-datavault/1898)
**Author:** [@julesKr](https://forum.data-community.org/u/julesKr)\ **Replies:** 3\ **Last updated:** [July 19, 2025, 1:26am UTC](https://forum.data-community.org/t/computation-in-datavault/1898 "2025-07-19T01:26:32Z")
Hello, I have stored my data in DataVault and need to do complex computations, which involve the entities from multiple schemas of the foundation layer. The results need to be persisted in the DataVault. What is the rig… --- ## [Conforming data from multiple systems...where does it happen?](https://forum.data-community.org/t/conforming-data-from-multiple-systems-where-does-it-happen/1870)
**Author:** [@mlord1979](https://forum.data-community.org/u/mlord1979)\ **Replies:** 6\ **Last updated:** [July 15, 2025, 2:27am UTC](https://forum.data-community.org/t/conforming-data-from-multiple-systems-where-does-it-happen/1870 "2025-07-15T02:27:16Z")
Hi, I have a scenario where we have some claims data from 2 source systems representing 2 different areas of the Business. Part of the requirement is to have one table with the claims from both systems. Whilst the 2 sour… --- ## [Different satellite load pattern for immutable data?](https://forum.data-community.org/t/different-satellite-load-pattern-for-immutable-data/1897)
**Author:** [@Frankie](https://forum.data-community.org/u/Frankie)\ **Replies:** 4\ **Last updated:** [July 11, 2025, 8:24am UTC](https://forum.data-community.org/t/different-satellite-load-pattern-for-immutable-data/1897 "2025-07-11T08:24:06Z")
Hi all, I was thinking today about entities that are largely immutable. We have a number of scenarios where once an entity is defined in our source it’s never changed. Those familiar with dimensional models will have ma… --- ## [Hub with many multi-active satellites](https://forum.data-community.org/t/hub-with-many-multi-active-satellites/1889)
**Author:** [@MariusvS](https://forum.data-community.org/u/MariusvS)\ **Replies:** 6\ **Last updated:** [July 2, 2025, 6:10pm UTC](https://forum.data-community.org/t/hub-with-many-multi-active-satellites/1889 "2025-07-02T18:10:42Z")
Hi. I have a raw data vault model that has a hub with about 15 satellites (all from a single source system) hanging off it. About half of those satellites are multi-active. My question is, is this unusual or is this c… --- ## [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)
**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")
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… --- ## [Links from multiple sources with differing relationships](https://forum.data-community.org/t/links-from-multiple-sources-with-differing-relationships/1875)
**Author:** [@mlord1979](https://forum.data-community.org/u/mlord1979)\ **Replies:** 4\ **Last updated:** [June 22, 2025, 4:21am UTC](https://forum.data-community.org/t/links-from-multiple-sources-with-differing-relationships/1875 "2025-06-22T04:21:16Z")
Hi I have 2 similar tables from 2 different source systems that have the same core identifiers but one table has some additional ones - Should I be trying to get these sources in to the same link table or should the… --- ## [Alternate id in another source system](https://forum.data-community.org/t/alternate-id-in-another-source-system/1863)
**Author:** [@tirdman](https://forum.data-community.org/u/tirdman)\ **Replies:** 3\ **Last updated:** [June 4, 2025, 3:31pm UTC](https://forum.data-community.org/t/alternate-id-in-another-source-system/1863 "2025-06-04T15:31:12Z")
Hello everyone! Perhaps the question has already been discussed, but unfortunately I couldn’t find it. There are 5 source systems. Sources are loaded independently of each other. In 4 of them the business key is pres… --- ## [Satelite on satelite approach](https://forum.data-community.org/t/satelite-on-satelite-approach/1854)
**Author:** [@CuriousMind](https://forum.data-community.org/u/CuriousMind)\ **Replies:** 4\ **Last updated:** [May 28, 2025, 7:36pm UTC](https://forum.data-community.org/t/satelite-on-satelite-approach/1854 "2025-05-28T19:36:55Z")
Dear All, In our data , we have two descriptive entities (satellites )depending on one main entity(hub) . One of these satellites is dependent on another. There are two ways to model this satellite in data vault - A… --- ## [Data Feed of Deltas: Candidate for Non-Historized Link?](https://forum.data-community.org/t/data-feed-of-deltas-candidate-for-non-historized-link/1843)
**Author:** [@MarkyMark](https://forum.data-community.org/u/MarkyMark)\ **Replies:** 3\ **Last updated:** [May 19, 2025, 1:47am UTC](https://forum.data-community.org/t/data-feed-of-deltas-candidate-for-non-historized-link/1843 "2025-05-19T01:47:57Z")
We are about to receive a data feed where the source data is being pushed to us once per day, and each day represents deltas. SourceFileName FILE\_NAME\_20250425210549.csv FILE\_NAME\_20250426210417.csv FILE\_NAM… --- ## [Teasing Business Keys out of variants of the Entity - Hotels!](https://forum.data-community.org/t/teasing-business-keys-out-of-variants-of-the-entity-hotels/1834)
**Author:** [@wow0609](https://forum.data-community.org/u/wow0609)\ **Replies:** 2\ **Last updated:** [April 29, 2025, 7:53am UTC](https://forum.data-community.org/t/teasing-business-keys-out-of-variants-of-the-entity-hotels/1834 "2025-04-29T07:53:31Z")
We are using dbt and AutomateDV for our project, dbt-Core since we are on MS SQL Server on-prem… I am also very new to this… We have been struggling to try to define a business key in our environment. I am trying to g… --- ## [Modeling Sales Event in DV 2.0](https://forum.data-community.org/t/modeling-sales-event-in-dv-2-0/1833)
**Author:** [@CuriousMind](https://forum.data-community.org/u/CuriousMind)\ **Replies:** 2\ **Last updated:** [April 23, 2025, 10:16am UTC](https://forum.data-community.org/t/modeling-sales-event-in-dv-2-0/1833 "2025-04-23T10:16:40Z")
Dear Forum , I have a question regarding Sales Event entity . Sales Event can be described as transaction between Dealer , Customer , Organization . Each Sales Event has related one or multiple Sales Event Item which c… --- ## [Staged to target check in testframework](https://forum.data-community.org/t/staged-to-target-check-in-testframework/1824)
**Author:** [@frank\_boekamp](https://forum.data-community.org/u/frank_boekamp)\ **Replies:** 3\ **Last updated:** [April 17, 2025, 8:39am UTC](https://forum.data-community.org/t/staged-to-target-check-in-testframework/1824 "2025-04-17T08:39:02Z")
We are building the test framework described in the book “The Data Vault Guru”. We have an issue with the supplied SQL code of the “Staged to target check” of SKEY and BKEY. For example on page 418 the SQL code of HUB\_SK… --- ## [Oracle Time Card Data - Transactional Links?](https://forum.data-community.org/t/oracle-time-card-data-transactional-links/715)
**Author:** [@MarkyMark](https://forum.data-community.org/u/MarkyMark)\ **Replies:** 5\ **Last updated:** [April 15, 2025, 12:40pm UTC](https://forum.data-community.org/t/oracle-time-card-data-transactional-links/715 "2025-04-15T12:40:36Z")
Hi. I’m trying to model employee time cards in Oracle in data vault. Can anyone give me some advice around the conceptual design, and would transactional links be best suited for this situation. I imagine that similar t… --- ## [Orphan check in satellite](https://forum.data-community.org/t/orphan-check-in-satellite/1817)
**Author:** [@frank\_boekamp](https://forum.data-community.org/u/frank_boekamp)\ **Replies:** 4\ **Last updated:** [April 14, 2025, 7:26am UTC](https://forum.data-community.org/t/orphan-check-in-satellite/1817 "2025-04-14T07:26:13Z")
We are building the test framework described in the book “The Data Vault Guru” and wondering about one specific test: the orphan check in the satellite (SAT\_SKEY\_ORPH): why does this query not use DV\_TENANTID in the join… --- ## [Multi Active Satelite or Normaization needed?](https://forum.data-community.org/t/multi-active-satelite-or-normaization-needed/1814)
**Author:** [@Dorry](https://forum.data-community.org/u/Dorry)\ **Replies:** 5\ **Last updated:** [April 13, 2025, 8:53am UTC](https://forum.data-community.org/t/multi-active-satelite-or-normaization-needed/1814 "2025-04-13T08:53:28Z")
Hi guys, first question here (i’m a data vault beginner :slight\_smile: ) Imagine having a source table with the following data |Client ID |Rating agentur (A/B) |Rating method (L/S) |Trustful (Y/N) |Raing data |Rating… --- ## [Flow.BI - any thoughts?](https://forum.data-community.org/t/flow-bi-any-thoughts/1812)
**Author:** [@jhall\_uk](https://forum.data-community.org/u/jhall_uk)\ **Replies:** 2\ **Last updated:** [April 11, 2025, 11:39am UTC](https://forum.data-community.org/t/flow-bi-any-thoughts/1812 "2025-04-11T11:39:37Z")
Has anyone come across Flow.BI? The tool looks to use AI smarts to simplify Data Vault model and pipeline development. I’m simply interested the views from this community on its capabilities. Link to tool web site --- ## [Satellite naming](https://forum.data-community.org/t/satellite-naming/1818)
**Author:** [@Rupa](https://forum.data-community.org/u/Rupa)\ **Replies:** 3\ **Last updated:** [April 11, 2025, 11:23am UTC](https://forum.data-community.org/t/satellite-naming/1818 "2025-04-11T11:23:49Z")
My Question is around naming of satellite: System A sends data to system B . System B passes the same data to EDW where we are doing RDV. System B is not doing any transformation of the data, it’s simply passing the da… --- ## [Loading a Link Satellite with Driving Key](https://forum.data-community.org/t/loading-a-link-satellite-with-driving-key/1639)
**Author:** [@BMendes](https://forum.data-community.org/u/BMendes)\ **Replies:** 2\ **Last updated:** [April 8, 2025, 2:09pm UTC](https://forum.data-community.org/t/loading-a-link-satellite-with-driving-key/1639 "2025-04-08T14:09:18Z")
Hello, forgive me if this topic has already been exhausted (I looked but haven’t found an answer anywhere), but I’m just not understanding something about how to load a link satellite using a driving key. I’m dealing wi… --- ## [XTS sample code](https://forum.data-community.org/t/xts-sample-code/1796)
**Author:** [@jhall\_uk](https://forum.data-community.org/u/jhall_uk)\ **Replies:** 2\ **Last updated:** [April 8, 2025, 11:34am UTC](https://forum.data-community.org/t/xts-sample-code/1796 "2025-04-08T11:34:39Z")
Hi everyone, I’ve read through articles relating to handling late arriving / out of sequence data and have read chapter 8 in Patrick’s book - all that cover off the Extended Tracking Satellite (XTS) Lots of sample pseu… --- ## [Data Feed with Multiple Link Characteristics](https://forum.data-community.org/t/data-feed-with-multiple-link-characteristics/1792)
**Author:** [@MarkyMark](https://forum.data-community.org/u/MarkyMark)\ **Replies:** 1\ **Last updated:** [April 7, 2025, 7:38am UTC](https://forum.data-community.org/t/data-feed-with-multiple-link-characteristics/1792 "2025-04-07T07:38:11Z")
So, we’re receiving a data feed that looks a bit like this… CHILD\_TYPE CHILD\_ID PARENT\_ID PARENT\_TYPE LINKTYPE START\_DATE END\_DATE We have multiple entity types, which in turn have multiple link type c… --- ## [Effective satellite for link of json source](https://forum.data-community.org/t/effective-satellite-for-link-of-json-source/1798)
**Author:** [@Rameshkumar](https://forum.data-community.org/u/Rameshkumar)\ **Replies:** 1\ **Last updated:** [April 7, 2025, 3:01am UTC](https://forum.data-community.org/t/effective-satellite-for-link-of-json-source/1798 "2025-04-07T03:01:04Z")
Hello everyone, Need some suggestion on below scenario, We have built a LNK\_\_SUPPLIER\_\_COMPANY from a source table in which we have json columns. The company details are present inside one of a json column. So we have … --- ## [Dimension code considering status trakcking sats](https://forum.data-community.org/t/dimension-code-considering-status-trakcking-sats/1787)
**Author:** [@DVBeginner](https://forum.data-community.org/u/DVBeginner)\ **Replies:** 0\ **Last updated:** [March 24, 2025, 9:38pm UTC](https://forum.data-community.org/t/dimension-code-considering-status-trakcking-sats/1787 "2025-03-24T21:38:49Z")
Hi I would like to validate a code template of virtualized dimension, that considers status tracking satellites. Concept\_PIT - regular PIT for a Concept, indexes both regular but also status tracking satellite Concept… --- ## [Transactions DCK to join objects?](https://forum.data-community.org/t/transactions-dck-to-join-objects/1765)
**Author:** [@mrjovana](https://forum.data-community.org/u/mrjovana)\ **Replies:** 4\ **Last updated:** [March 21, 2025, 9:14am UTC](https://forum.data-community.org/t/transactions-dck-to-join-objects/1765 "2025-03-21T09:14:14Z")
Hey, Do y’all have any suggestions for the following: If I want to model transactions as regular links storing only real business entites relationships, and put all other information together with transaction’s unique … --- ## [Business Entity with multiple Business Keys](https://forum.data-community.org/t/business-entity-with-multiple-business-keys/1771)
**Author:** [@Yngidata](https://forum.data-community.org/u/Yngidata)\ **Replies:** 1\ **Last updated:** [March 19, 2025, 7:48pm UTC](https://forum.data-community.org/t/business-entity-with-multiple-business-keys/1771 "2025-03-19T19:48:58Z")
Hi everyone, got a situation where we have a satellite for a table that is about regions. We have abbreviation name integer surrogate key salesforce key Depending on the table is depending on which one of these is use… --- ## [Is an interaction a hub?](https://forum.data-community.org/t/is-an-interaction-a-hub/1759)
**Author:** [@MarkyMark](https://forum.data-community.org/u/MarkyMark)\ **Replies:** 8\ **Last updated:** [March 18, 2025, 1:51am UTC](https://forum.data-community.org/t/is-an-interaction-a-hub/1759 "2025-03-18T01:51:06Z")
So, there’s a bit of a debate around whether interactions originating from various CRMs should have a hub or not. I stand corrected if I’m wrong, but to me the interaction is not a participant. For example, we have a s… [Previous page](https://forum.data-community.org/c/datavault-2-0/5.md) [Next page](https://forum.data-community.org/c/datavault-2-0/5.md?page=2)