# \#hub **URL:** https://forum.data-community.org/tag/hub/27.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) --- ## [Experience Modeling ACDOCA](https://forum.data-community.org/t/experience-modeling-acdoca/2112)
**Author:** [@asouissi](https://forum.data-community.org/u/asouissi)\ **Replies:** 0\ **Last updated:** [June 3, 2026, 2:30pm UTC](https://forum.data-community.org/t/experience-modeling-acdoca/2112 "2026-06-03T14:30:21Z")
Hi everyone, We’re currently working on integrating SAP FI data into a client’s Data Vault. One of the key source tables is ACDOCA (Universal Journal line items), and we’re evaluating how best to model it in the Raw Vau… --- ## [DV Modelling Is Hard](https://forum.data-community.org/t/dv-modelling-is-hard/2055)
**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")
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… --- ## [Multiple (not composite) business keys in the same hub](https://forum.data-community.org/t/multiple-not-composite-business-keys-in-the-same-hub/2053)
**Author:** [@maksil](https://forum.data-community.org/u/maksil)\ **Replies:** 6\ **Last updated:** [March 12, 2026, 10:57am UTC](https://forum.data-community.org/t/multiple-not-composite-business-keys-in-the-same-hub/2053 "2026-03-12T10:57:46Z")
Hi All, I have 2 distinct business keys linked with the same business entity. One of them (A) has full coverage for underlying entity, while another (B) is better known to the business users but is not always present. … --- ## [Composite business keys or dependent child keys](https://forum.data-community.org/t/composite-business-keys-or-dependent-child-keys/1975)
**Author:** [@mlord1979](https://forum.data-community.org/u/mlord1979)\ **Replies:** 5\ **Last updated:** [January 30, 2026, 4:01pm UTC](https://forum.data-community.org/t/composite-business-keys-or-dependent-child-keys/1975 "2026-01-30T16:01:17Z")
Hi, I have a scenario where I am trying to model claims data. A claim has a claim id as it’s unique identifier so we have a claim hub, the claim can have multiple versions if it needs to be modified after it has been fin… --- ## [Modeling Customer-API Interactions](https://forum.data-community.org/t/modeling-customer-api-interactions/1928)
**Author:** [@Bwillms](https://forum.data-community.org/u/Bwillms)\ **Replies:** 4\ **Last updated:** [August 18, 2025, 6:20pm UTC](https://forum.data-community.org/t/modeling-customer-api-interactions/1928 "2025-08-18T18:20:20Z")
I’m hoping to get some feedback on a possible approach for representing API endpoint interactions by our customers. One of our key product offerings to customers is access to our APIs and we’re trying to bring in our cu… --- ## [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… --- ## [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… --- ## [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… --- ## [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… --- ## [Business subject but no business key](https://forum.data-community.org/t/business-subject-but-no-business-key/1744)
**Author:** [@justinV](https://forum.data-community.org/u/justinV)\ **Replies:** 4\ **Last updated:** [February 27, 2025, 2:31pm UTC](https://forum.data-community.org/t/business-subject-but-no-business-key/1744 "2025-02-27T14:31:55Z")
Hello everyone, I’m seeking advice on modeling my DV. Our team focuses on fraud and corporate solvency risks. We’ve collaborated with the business team to identify key business objects : company, contract, financial st… --- ## [Multi hub from one source. Split the satellite ?](https://forum.data-community.org/t/multi-hub-from-one-source-split-the-satellite/1687)
**Author:** [@justinV](https://forum.data-community.org/u/justinV)\ **Replies:** 4\ **Last updated:** [January 31, 2025, 9:42am UTC](https://forum.data-community.org/t/multi-hub-from-one-source-split-the-satellite/1687 "2025-01-31T09:42:08Z")
Hi everybody! I need some advice regarding best practices in hub/satellite modelisation. I have 2 hub : hub\_employee and hub\_company I have a source that give me data about employee AND company (a bool on each line s… --- ## [Hub - Link - Satellite ](https://forum.data-community.org/t/hub-link-satellite/1617)
**Author:** [@JaimeVadell](https://forum.data-community.org/u/JaimeVadell)\ **Replies:** 1\ **Last updated:** [November 25, 2024, 9:55pm UTC](https://forum.data-community.org/t/hub-link-satellite/1617 "2024-11-25T21:55:15Z")
Hello everyone, I have a question regarding Data Vault 2.0 modeling. Is it valid to establish a connection between a hub, a link, and a satellite, considering there is only one hub involved in the relationship? The cha… --- ## [Composite key , more than 1 business keys](https://forum.data-community.org/t/composite-key-more-than-1-business-keys/1575)
**Author:** [@CuriousMind](https://forum.data-community.org/u/CuriousMind)\ **Replies:** 5\ **Last updated:** [November 10, 2024, 9:57pm UTC](https://forum.data-community.org/t/composite-key-more-than-1-business-keys/1575 "2024-11-10T21:57:06Z")
Hello All, We have many entities where we have more than 1 business keys (composite key) . Is it better to have them concatenated together as a single business key or keep them as different columns ? What is the impac… --- ## [REC\_SRC attribute in hub , link or satelites](https://forum.data-community.org/t/rec-src-attribute-in-hub-link-or-satelites/1559)
**Author:** [@CuriousMind](https://forum.data-community.org/u/CuriousMind)\ **Replies:** 2\ **Last updated:** [October 23, 2024, 12:32am UTC](https://forum.data-community.org/t/rec-src-attribute-in-hub-link-or-satelites/1559 "2024-10-23T00:32:48Z")
We have business entities where sourcename is the part of composite keys , since we get data from 3 or 4 different sources for same entity . So can we map sourcename to REC\_SRC ? Or have 2 different columns sourcename & … --- ## [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)
**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")
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… --- ## [More then one bkey in hub table](https://forum.data-community.org/t/more-then-one-bkey-in-hub-table/1507)
**Author:** [@rpalo](https://forum.data-community.org/u/rpalo)\ **Replies:** 5\ **Last updated:** [September 24, 2024, 10:28am UTC](https://forum.data-community.org/t/more-then-one-bkey-in-hub-table/1507 "2024-09-24T10:28:27Z")
Hi Everyone, Looking for a recommendation to define a HUB table with multiple Business key value? Is it advisable to define HUB table in DV model? TIA --- ## [Column aliasing in HUBs and LINKS](https://forum.data-community.org/t/column-aliasing-in-hubs-and-links/1408)
**Author:** [@Sushmitha](https://forum.data-community.org/u/Sushmitha)\ **Replies:** 1\ **Last updated:** [July 15, 2024, 10:50pm UTC](https://forum.data-community.org/t/column-aliasing-in-hubs-and-links/1408 "2024-07-15T22:50:08Z")
Hello, we have a requirement to load a column from stage as different column name in hub and satellite. We were able to use alias in satellites but not in hubs and links. Is it possible to enable column aliasing in hubs … --- ## [Should HUB be loaded only from actual source and how to define- biz. key if 2 source have diff. keys](https://forum.data-community.org/t/should-hub-be-loaded-only-from-actual-source-and-how-to-define-biz-key-if-2-source-have-diff-keys/1377)
**Author:** [@rjain101](https://forum.data-community.org/u/rjain101)\ **Replies:** 5\ **Last updated:** [July 3, 2024, 10:56pm UTC](https://forum.data-community.org/t/should-hub-be-loaded-only-from-actual-source-and-how-to-define-biz-key-if-2-source-have-diff-keys/1377 "2024-07-03T22:56:44Z")
I have a system , I have mimicked using Customer Product analogy as in diagram below Based on this System -C always has subset of customers from System-A and System-B and produces some data sets (50+ in number) for … --- ## [Super Type and sub type](https://forum.data-community.org/t/super-type-and-sub-type/574)
**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")
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… --- ## [Multiple Health care sources in DV 2.0](https://forum.data-community.org/t/multiple-health-care-sources-in-dv-2-0/1322)
**Author:** [@Amro](https://forum.data-community.org/u/Amro)\ **Replies:** 0\ **Last updated:** [May 27, 2024, 1:33pm UTC](https://forum.data-community.org/t/multiple-health-care-sources-in-dv-2-0/1322 "2024-05-27T13:33:25Z")
Hello DV Community, I’m working on creating a DV of Multiple EMR systems and at a fork between single vs multiple hub dilemma. Background: Encounters are defined differently in every EMR system, for simplicity using on… --- ## [Change in Primary Key at source](https://forum.data-community.org/t/change-in-primary-key-at-source/1288)
**Author:** [@mpols](https://forum.data-community.org/u/mpols)\ **Replies:** 2\ **Last updated:** [May 16, 2024, 5:13pm UTC](https://forum.data-community.org/t/change-in-primary-key-at-source/1288 "2024-05-16T17:13:07Z")
One of our hubs is central to rest of our Data Vault. Meaning, 80% of our satellites are hanging off this hub. Consultants who came in first to build this 1st one of our hubs had little idea as to what data field is ide… --- ## [Hubs and dependent Hubs](https://forum.data-community.org/t/hubs-and-dependent-hubs/1242)
**Author:** [@MattTheFatt](https://forum.data-community.org/u/MattTheFatt)\ **Replies:** 5\ **Last updated:** [May 2, 2024, 2:32pm UTC](https://forum.data-community.org/t/hubs-and-dependent-hubs/1242 "2024-05-02T14:32:37Z")
Hey all, Here’s my (Healthcare) scenario: I have a hub entity called H\_Payor. Each payor has a number of Benefit Plans. Benefit plans only exist in reference to a specific Payer. Modeling question : Do we create a hub … --- ## [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)
**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")
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… --- ## [Re-using business keys across hubs? Or use child dependent key?](https://forum.data-community.org/t/re-using-business-keys-across-hubs-or-use-child-dependent-key/1187)
**Author:** [@evan.phillips](https://forum.data-community.org/u/evan.phillips)\ **Replies:** 1\ **Last updated:** [February 27, 2024, 6:16am UTC](https://forum.data-community.org/t/re-using-business-keys-across-hubs-or-use-child-dependent-key/1187 "2024-02-27T06:16:13Z")
Hi all, I’m working on a project that models political campaign finance data and the source system data we are using is messy to say the least. The business objects we’ve landed on for this specific case are Committee, … --- ## [Is non-historized link a way to go?](https://forum.data-community.org/t/is-non-historized-link-a-way-to-go/1168)
**Author:** [@kmy](https://forum.data-community.org/u/kmy)\ **Replies:** 1\ **Last updated:** [February 12, 2024, 11:17pm UTC](https://forum.data-community.org/t/is-non-historized-link-a-way-to-go/1168 "2024-02-12T23:17:01Z")
Hello, I am very new to Data vault, so I would like to have a sanity check, if it is a way to go… So there are Order table and Calculated\_price table, that stores all calculated prices generated by price microservice. … --- ## [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)
**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")
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… --- ## [Salesforce Object Modelling To Hub Without A Business Key?](https://forum.data-community.org/t/salesforce-object-modelling-to-hub-without-a-business-key/1067)
**Author:** [@ronny214](https://forum.data-community.org/u/ronny214)\ **Replies:** 3\ **Last updated:** [November 27, 2023, 7:52pm UTC](https://forum.data-community.org/t/salesforce-object-modelling-to-hub-without-a-business-key/1067 "2023-11-27T19:52:34Z")
Hi - We have a customer that we are implementing DV for, but they have a couple of Objects in Salesforce (tables) that do not have a logical business key (and do not live in other systems). For the list of about 30 tha… --- ## [Merge information of two links](https://forum.data-community.org/t/merge-information-of-two-links/912)
**Author:** [@nasifricio](https://forum.data-community.org/u/nasifricio)\ **Replies:** 1\ **Last updated:** [October 29, 2023, 8:33am UTC](https://forum.data-community.org/t/merge-information-of-two-links/912 "2023-10-29T08:33:28Z")
Hi Amazing folks, I am new to this community and I’m trying to model my first DB in DV2. I need your support because I don’t know how to design a specific requirement of our application. In the model I have 2 differen… --- ## [Recycled business key](https://forum.data-community.org/t/recycled-business-key/829)
**Author:** [@mloghin](https://forum.data-community.org/u/mloghin)\ **Replies:** 5\ **Last updated:** [October 28, 2023, 7:31pm UTC](https://forum.data-community.org/t/recycled-business-key/829 "2023-10-28T19:31:31Z")
Hi everybody! I need some advice regarding best practices in hub and defining the business key - precisely on how to represent a recycled business key. My situation: I have a source table providing the business key (C… --- ## [One or More Hubs for same Entity](https://forum.data-community.org/t/one-or-more-hubs-for-same-entity/950)
**Author:** [@luissimoes](https://forum.data-community.org/u/luissimoes)\ **Replies:** 2\ **Last updated:** [August 21, 2023, 11:37pm UTC](https://forum.data-community.org/t/one-or-more-hubs-for-same-entity/950 "2023-08-21T23:37:56Z")
Hi everyone, I have a set of three different data sources having data related to an entity (lets say customer). Each source has a set of attributes and keys. Between sources these attributes and keys may be similar or … [Next page](https://forum.data-community.org/tag/hub/27.md?match_all_tags=true&page=1&tags%5B%5D=hub)