# Top

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

[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:** 4

---

## [dbtvault update a flag column in old row](https://forum.data-community.org/t/dbtvault-update-a-flag-column-in-old-row/446)

<div class="topic-metadata">

**Author:** [@zarrar](https://forum.data-community.org/u/zarrar)\
**Replies:** 3\
**Last updated:** [November 2, 2022, 2:11pm UTC](https://forum.data-community.org/t/dbtvault-update-a-flag-column-in-old-row/446 "2022-11-02T14:11:34Z")

</div>

Hi, new to this group and using dbt. I was wondering while loading sat tables using incremental load, if the unique key exists but the values of the rest of the row is changing, can dbtvault keep the old row but modify …

---

## [Naming, Non-historized Links and Source Data](https://forum.data-community.org/t/naming-non-historized-links-and-source-data/888)

<div class="topic-metadata">

**Author:** [@GideonJvV](https://forum.data-community.org/u/GideonJvV)\
**Replies:** 2\
**Last updated:** [July 6, 2023, 11:17am UTC](https://forum.data-community.org/t/naming-non-historized-links-and-source-data/888 "2023-07-06T11:17:14Z")

</div>

I need some clarification on an aspect of non-historized links that I somehow failed to notice during my CDVP certification. So, simply stated, links relate business concepts, and satellite provide the context. So far s…

---

## [Thin BSATs in projects, is this best practices?](https://forum.data-community.org/t/thin-bsats-in-projects-is-this-best-practices/1970)

<div class="topic-metadata">

**Author:** [@Frankie](https://forum.data-community.org/u/Frankie)\
**Replies:** 4\
**Last updated:** [May 29, 2026, 8:09am UTC](https://forum.data-community.org/t/thin-bsats-in-projects-is-this-best-practices/1970 "2026-05-29T08:09:09Z")

</div>

Hi all, Been a bit quiet here so figured I’d post something that’s more of a feeler than an issue. I’ve noticed a trend when maintaining long running vault projects and figured it’d be good to crowd source some knowledg…

---

## [Zero keys and ghost records in Reference structures](https://forum.data-community.org/t/zero-keys-and-ghost-records-in-reference-structures/749)

<div class="topic-metadata">

**Author:** [@DVBeginner](https://forum.data-community.org/u/DVBeginner)\
**Replies:** 5\
**Last updated:** [May 9, 2023, 9:21pm UTC](https://forum.data-community.org/t/zero-keys-and-ghost-records-in-reference-structures/749 "2023-05-09T21:21:11Z")

</div>

Hello, I’m aware of standard to define 0-keys and ghost records for the DV objects. Do you apply the same in reference objects (reference and reference satellite table)? By default Ref objects do not have hash keys, t…

---

## [Satellite naming](https://forum.data-community.org/t/satellite-naming/1818)

<div class="topic-metadata">

**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")

</div>

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 Near Real Time Data into the Data Vault](https://forum.data-community.org/t/loading-near-real-time-data-into-the-data-vault/770)

<div class="topic-metadata">

**Author:** [@Bigguy365](https://forum.data-community.org/u/Bigguy365)\
**Replies:** 5\
**Last updated:** [April 29, 2023, 1:01pm UTC](https://forum.data-community.org/t/loading-near-real-time-data-into-the-data-vault/770 "2023-04-29T13:01:33Z")

</div>

We’ve just implemented a Chatbot and are receiving data from it into our data lake. We want to load it into our Data Vault that resides in an Azure Synapse Database. According to the Data Vault recommendations, this dat…

---

## [Loading from multiple sources to form a union-based transactional link](https://forum.data-community.org/t/loading-from-multiple-sources-to-form-a-union-based-transactional-link/800)

<div class="topic-metadata">

**Author:** [@Hugo](https://forum.data-community.org/u/Hugo)\
**Replies:** 4\
**Last updated:** [January 2, 2024, 9:09am UTC](https://forum.data-community.org/t/loading-from-multiple-sources-to-form-a-union-based-transactional-link/800 "2024-01-02T09:09:56Z")

</div>

Hello, I need to implement a transactional link in dbtvault with two sources. In the dbtvault documentation, it is said that it is possible to do that for Links, but it is not for possible transactional links. What worka…

---

## [Clarification on what satellites are involved in a PIT table ](https://forum.data-community.org/t/clarification-on-what-satellites-are-involved-in-a-pit-table/366)

<div class="topic-metadata">

**Author:** [@JanetMcF](https://forum.data-community.org/u/JanetMcF)\
**Replies:** 2\
**Last updated:** [July 19, 2022, 12:49am UTC](https://forum.data-community.org/t/clarification-on-what-satellites-are-involved-in-a-pit-table/366 "2022-07-19T00:49:22Z")

</div>

I am struggling with defining what becomes a Point in Time (PIT) table for a HUB. Is it a combination of a HUB and ALL of the Satellites that relate to it, or do you build one PIT for a HUB and each individual satellite…

---

## [A question on handling third party data](https://forum.data-community.org/t/a-question-on-handling-third-party-data/773)

<div class="topic-metadata">

**Author:** [@andy](https://forum.data-community.org/u/andy)\
**Replies:** 8\
**Last updated:** [May 9, 2023, 12:06pm UTC](https://forum.data-community.org/t/a-question-on-handling-third-party-data/773 "2023-05-09T12:06:52Z")

</div>

Hi there, Hoping someone might be able to provide some guidance here. Assume we have a customer hub. We’re sourcing data from Salesforce, and are using the Salesforce ID from the contact table as our business key. We …

---

## [Modeling different events for an Order](https://forum.data-community.org/t/modeling-different-events-for-an-order/1247)

<div class="topic-metadata">

**Author:** [@Sandeep](https://forum.data-community.org/u/Sandeep)\
**Replies:** 5\
**Last updated:** [May 16, 2024, 11:24pm UTC](https://forum.data-community.org/t/modeling-different-events-for-an-order/1247 "2024-05-16T23:24:10Z")

</div>

Hi All, Sorry if this is something very basic but I’m new to DV 2.0 and would like to understand modelling approach for my use case. We need to ingest order event data into DV layer. The order has multiple events and …

---

## [Should Hub definition follow source system structure or business entities?](https://forum.data-community.org/t/should-hub-definition-follow-source-system-structure-or-business-entities/2019)

<div class="topic-metadata">

**Author:** [@AlPetMaggioli](https://forum.data-community.org/u/AlPetMaggioli)\
**Replies:** 4\
**Last updated:** [January 26, 2026, 3:09pm UTC](https://forum.data-community.org/t/should-hub-definition-follow-source-system-structure-or-business-entities/2019 "2026-01-26T15:09:08Z")

</div>

Hello everyone, I am a newbie to Data Vault modeling and I am having some doubts regarding the architecture I have built so far. A thing that is not clear to me is whether the DV entities definition should follow the s…

---

## [Excluding data towards RDV that has no business value](https://forum.data-community.org/t/excluding-data-towards-rdv-that-has-no-business-value/702)

<div class="topic-metadata">

**Author:** [@FrenkLoonen](https://forum.data-community.org/u/FrenkLoonen)\
**Replies:** 6\
**Last updated:** [March 23, 2023, 1:40pm UTC](https://forum.data-community.org/t/excluding-data-towards-rdv-that-has-no-business-value/702 "2023-03-23T13:40:36Z")

</div>

Hi all, I’m struggling with the decision to exclude data with no business value when loading the Raw Data Vault. After all, we should be able to recreate the source file from an auditability POV… Which is why I also try…

---

## [Multi-active Satellites](https://forum.data-community.org/t/multi-active-satellites/866)

<div class="topic-metadata">

**Author:** [@DikshaSaha](https://forum.data-community.org/u/DikshaSaha)\
**Replies:** 2\
**Last updated:** [December 12, 2024, 9:52pm UTC](https://forum.data-community.org/t/multi-active-satellites/866 "2024-12-12T21:52:04Z")

</div>

Has anyone here implemented multi-active satellites using Automate DV package of DBT? I have a scenario of creating Data Vault on an XML file data. This file is having multiple nested elements for each unique identifier…

---

## [Now I've built my datavault - how do I prove that it is right?](https://forum.data-community.org/t/now-ive-built-my-datavault-how-do-i-prove-that-it-is-right/439)

<div class="topic-metadata">

**Author:** [@Rusty](https://forum.data-community.org/u/Rusty)\
**Replies:** 5\
**Last updated:** [September 25, 2022, 8:44pm UTC](https://forum.data-community.org/t/now-ive-built-my-datavault-how-do-i-prove-that-it-is-right/439 "2022-09-25T20:44:00Z")

</div>

I’ve built a realtime DV with the 1st data source being a new D365 app. What does testing a DV look like? Are there established frameworks and tools? Do you all roll-you-own? I have built a pilot, secured a budget and…

---

## [Selecting a column named "delete" in the dbt query to create a Staging VIEW](https://forum.data-community.org/t/selecting-a-column-named-delete-in-the-dbt-query-to-create-a-staging-view/329)

<div class="topic-metadata">

**Author:** [@saqib](https://forum.data-community.org/u/saqib)\
**Replies:** 4\
**Last updated:** [June 21, 2022, 1:32pm UTC](https://forum.data-community.org/t/selecting-a-column-named-delete-in-the-dbt-query-to-create-a-staging-view/329 "2022-06-21T13:32:38Z")

</div>

I am trying to create a VIEW in dbt. The source table has a column named delete. How do I select this column in the select query in DBT? I tried : select id, delete from src\_table; select id, "delete" from src\_table; …

---

## [Using Denodo after Raw Data Vault](https://forum.data-community.org/t/using-denodo-after-raw-data-vault/919)

<div class="topic-metadata">

**Author:** [@Nikunj](https://forum.data-community.org/u/Nikunj)\
**Replies:** 0\
**Last updated:** [July 25, 2023, 4:14pm UTC](https://forum.data-community.org/t/using-denodo-after-raw-data-vault/919 "2023-07-25T16:14:51Z")

</div>

Once the data is loaded to Data Vault tables, Has anyone used Denodo for creating virtual dimensions and facts? There is an option to cache on denodo. I plan to use cache in denodo for the PIT and BRIDGE tables instead …

---

## [Modeling Salesforce CASE and JIRA Issue](https://forum.data-community.org/t/modeling-salesforce-case-and-jira-issue/113)

<div class="topic-metadata">

**Author:** [@saqib](https://forum.data-community.org/u/saqib)\
**Replies:** 8\
**Last updated:** [January 28, 2022, 4:43pm UTC](https://forum.data-community.org/t/modeling-salesforce-case-and-jira-issue/113 "2022-01-28T16:43:42Z")

</div>

Hello all, We are working on modeling the Salesforce CASE and JIRA Issues. Salesforce is our primary CASE tracking system where the customers open their CASE. Most CASEs are resolved as a CASE. However some cases becom…

---

## [PIT, MAS, and Bridge Tables — Do They Belong to the Raw Vault or the Business Vault?](https://forum.data-community.org/t/pit-mas-and-bridge-tables-do-they-belong-to-the-raw-vault-or-the-business-vault/2085)

<div class="topic-metadata">

**Author:** [@julia](https://forum.data-community.org/u/julia)\
**Replies:** 4\
**Last updated:** [May 29, 2026, 9:07am UTC](https://forum.data-community.org/t/pit-mas-and-bridge-tables-do-they-belong-to-the-raw-vault-or-the-business-vault/2085 "2026-05-29T09:07:33Z")

</div>

Hi all, I’m currently working on a Data Vault 2.0 project and have a question regarding modeling layers. Do PIT and bridge tables belong to the Raw Vault or the Business Vault layer? From my perspective, PIT tables se…

---

## [Understanding Effective\_dates with starts and ends](https://forum.data-community.org/t/understanding-effective-dates-with-starts-and-ends/384)

<div class="topic-metadata">

**Author:** [@gchoong](https://forum.data-community.org/u/gchoong)\
**Replies:** 1\
**Last updated:** [August 7, 2022, 7:33am UTC](https://forum.data-community.org/t/understanding-effective-dates-with-starts-and-ends/384 "2022-08-07T07:33:48Z")

</div>

For the effective from columns (src\_eff) of a satellite, how does it handle the previous record with the ‘old’ name? Documentation said that it isn’t valid, but what if we need to go back and query the old records? How d…

---

## [Recycled business key](https://forum.data-community.org/t/recycled-business-key/829)

<div class="topic-metadata">

**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")

</div>

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…

---

## [SAL is killing me](https://forum.data-community.org/t/sal-is-killing-me/1104)

<div class="topic-metadata">

**Author:** [@andy](https://forum.data-community.org/u/andy)\
**Replies:** 6\
**Last updated:** [January 10, 2024, 10:36am UTC](https://forum.data-community.org/t/sal-is-killing-me/1104 "2024-01-10T10:36:06Z")

</div>

I’m hoping someone can please show me a cleaner way to do this. I want to create a type 1 dimension based off a hub, two satellites (for systems A and B) and a same-as-link. Not all records in system A exist in system B,…

---

## [Non-historized or Sat Dependent Child Key](https://forum.data-community.org/t/non-historized-or-sat-dependent-child-key/1160)

<div class="topic-metadata">

**Author:** [@rudra](https://forum.data-community.org/u/rudra)\
**Replies:** 6\
**Last updated:** [February 9, 2024, 4:30pm UTC](https://forum.data-community.org/t/non-historized-or-sat-dependent-child-key/1160 "2024-02-09T16:30:03Z")

</div>

Hello, I need to design for Orders, Order Lines, Shipment. In summary, they all from sales order process. These table contains main key details such as Orders: Order number Customer Number Order Type, Order Date, e…

---

## [Raw Data Vault Drop test](https://forum.data-community.org/t/raw-data-vault-drop-test/857)

<div class="topic-metadata">

**Author:** [@Nikunj](https://forum.data-community.org/u/Nikunj)\
**Replies:** 0\
**Last updated:** [June 20, 2023, 6:37am UTC](https://forum.data-community.org/t/raw-data-vault-drop-test/857 "2023-06-20T06:37:21Z")

</div>

Dear All, Has anyone explored how the mechanism for recreating the whole Raw Data Vault from the persistent staging area files? I would assume that Raw Data sets should be available. Some special processes to handle …

---

## [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)

<div class="topic-metadata">

**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")

</div>

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 a Row vault from an OLTP having composite primary key.](https://forum.data-community.org/t/modeling-a-row-vault-from-an-oltp-having-composite-primary-key/844)

<div class="topic-metadata">

**Author:** [@Irfan](https://forum.data-community.org/u/Irfan)\
**Replies:** 3\
**Last updated:** [June 15, 2023, 11:29pm UTC](https://forum.data-community.org/t/modeling-a-row-vault-from-an-oltp-having-composite-primary-key/844 "2023-06-15T23:29:31Z")

</div>

I have three primary tables (Customers, Employees, and Shippers) and a child table, Orders, where Orders is the child of all three primary entities. In the Orders table, OrderID is not unique, so it can’t be made the pr…

---

## [Dbtvault macro for loading HUB from two different source with different number of BKs](https://forum.data-community.org/t/dbtvault-macro-for-loading-hub-from-two-different-source-with-different-number-of-bks/313)

<div class="topic-metadata">

**Author:** [@saqib](https://forum.data-community.org/u/saqib)\
**Replies:** 5\
**Last updated:** [June 10, 2022, 7:46pm UTC](https://forum.data-community.org/t/dbtvault-macro-for-loading-hub-from-two-different-source-with-different-number-of-bks/313 "2022-06-10T19:46:02Z")

</div>

Hello, Using dbtvault how do I load a HUB from two different sources with different number of BKs. One source uses 3 part composite BK and the other system uses a 4 part composite BK. Please advise. Thanks. cc: @alex.…

---

## [DQ issues: Error Vault?](https://forum.data-community.org/t/dq-issues-error-vault/351)

<div class="topic-metadata">

**Author:** [@FrenkLoonen](https://forum.data-community.org/u/FrenkLoonen)\
**Replies:** 4\
**Last updated:** [August 7, 2022, 7:41am UTC](https://forum.data-community.org/t/dq-issues-error-vault/351 "2022-08-07T07:41:47Z")

</div>

I need to load Company data. The BK is the DUNS number (with which many of you will probably be familiar). I’ll be receiving full snapshots every day. The source table PK is DUNS + DUNS\_TS, the timestamp of when the info…

---

## [Loading Chatbot Data into the Data Vault](https://forum.data-community.org/t/loading-chatbot-data-into-the-data-vault/742)

<div class="topic-metadata">

**Author:** [@Bigguy365](https://forum.data-community.org/u/Bigguy365)\
**Replies:** 0\
**Last updated:** [April 11, 2023, 6:37pm UTC](https://forum.data-community.org/t/loading-chatbot-data-into-the-data-vault/742 "2023-04-11T18:37:34Z")

</div>

This is in the wrong place. Please ignore.

---

## [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)

<div class="topic-metadata">

**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")

</div>

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…

---

## [More then one bkey in hub table](https://forum.data-community.org/t/more-then-one-bkey-in-hub-table/1507)

<div class="topic-metadata">

**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")

</div>

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

---

## [ETL pattern for Stage-\>DV](https://forum.data-community.org/t/etl-pattern-for-stage-dv/1261)

<div class="topic-metadata">

**Author:** [@KostyaRico](https://forum.data-community.org/u/KostyaRico)\
**Replies:** 6\
**Last updated:** [May 22, 2024, 9:12pm UTC](https://forum.data-community.org/t/etl-pattern-for-stage-dv/1261 "2024-05-22T21:12:45Z")

</div>

Hello, dear community! I’ve been figuring out for my self the best approach for loading pattern of the DV core objects from staging tables. Lets us having N staging tables from M source systems. What is the best appro…

---

## [New DV project - First steps](https://forum.data-community.org/t/new-dv-project-first-steps/483)

<div class="topic-metadata">

**Author:** [@jbo](https://forum.data-community.org/u/jbo)\
**Replies:** 3\
**Last updated:** [November 4, 2022, 5:37am UTC](https://forum.data-community.org/t/new-dv-project-first-steps/483 "2022-11-04T05:37:21Z")

</div>

Hi together, we are currently planning to map three ERP systems from different locations in one DV model and to integrate further ERP systems later. The three ERP systems are based on MS Dynamics NAV 2016 and are struc…

---

## [Data Vault User Group Conference 2023](https://forum.data-community.org/t/data-vault-user-group-conference-2023/916)

<div class="topic-metadata">

**Author:** [@anon83229795](https://forum.data-community.org/u/anon83229795)\
**Replies:** 0\
**Last updated:** [July 24, 2023, 12:48pm UTC](https://forum.data-community.org/t/data-vault-user-group-conference-2023/916 "2023-07-24T12:48:04Z")

</div>

Hi all, Just wanted to announce that the Data Vault User Group is hosting a conference this year! 6th-7th September at the Royal Holloway University Campus near London’s Heathrow airport. There are lots of interesting …

---

## [Reference Data Models](https://forum.data-community.org/t/reference-data-models/576)

<div class="topic-metadata">

**Author:** [@ben.wright](https://forum.data-community.org/u/ben.wright)\
**Replies:** 2\
**Last updated:** [February 5, 2023, 10:01pm UTC](https://forum.data-community.org/t/reference-data-models/576 "2023-02-05T22:01:59Z")

</div>

What does everybody think about using reference/template models?

---

## [HUB or LNK/DC when unit of work is different for source files for the same BK](https://forum.data-community.org/t/hub-or-lnk-dc-when-unit-of-work-is-different-for-source-files-for-the-same-bk/846)

<div class="topic-metadata">

**Author:** [@Houghster](https://forum.data-community.org/u/Houghster)\
**Replies:** 3\
**Last updated:** [June 21, 2023, 1:26am UTC](https://forum.data-community.org/t/hub-or-lnk-dc-when-unit-of-work-is-different-for-source-files-for-the-same-bk/846 "2023-06-21T01:26:40Z")

</div>

Hi all, I have a issue getting my head around what seems like a simple model in terms of whether an object should be a HUB or a LNK with a DC. To set a simple picture, we digest transactional data from a CDC and our DV …

---

## [Must I re-engineer the DV when I add a new source with a possible collision to a hub table?](https://forum.data-community.org/t/must-i-re-engineer-the-dv-when-i-add-a-new-source-with-a-possible-collision-to-a-hub-table/1155)

<div class="topic-metadata">

**Author:** [@apressler](https://forum.data-community.org/u/apressler)\
**Replies:** 1\
**Last updated:** [February 7, 2024, 2:40am UTC](https://forum.data-community.org/t/must-i-re-engineer-the-dv-when-i-add-a-new-source-with-a-possible-collision-to-a-hub-table/1155 "2024-02-07T02:40:57Z")

</div>

We are integrating a new system into an existing vault. The existing DV is sourced from the “Enterprise” system and the new system “Access” holds information about security access such as card swipes at doors (the curren…

---

## [How can I control the referential integrity in Link and satellite during parallel loading?](https://forum.data-community.org/t/how-can-i-control-the-referential-integrity-in-link-and-satellite-during-parallel-loading/1466)

<div class="topic-metadata">

**Author:** [@Sudi](https://forum.data-community.org/u/Sudi)\
**Replies:** 6\
**Last updated:** [August 15, 2024, 4:10am UTC](https://forum.data-community.org/t/how-can-i-control-the-referential-integrity-in-link-and-satellite-during-parallel-loading/1466 "2024-08-15T04:10:42Z")

</div>

Hello, I’m implementing the SQL script to create and load data into the target Hubs/Links and satellites. How can we manage the referential integrity of links and satellites to prevent them from having any orphaned rec…

---

## [Need help on Building and Maintaining PiTs](https://forum.data-community.org/t/need-help-on-building-and-maintaining-pits/1028)

<div class="topic-metadata">

**Author:** [@DataDude](https://forum.data-community.org/u/DataDude)\
**Replies:** 2\
**Last updated:** [October 28, 2023, 7:14pm UTC](https://forum.data-community.org/t/need-help-on-building-and-maintaining-pits/1028 "2023-10-28T19:14:58Z")

</div>

It’s the PiTs! It’s not often you get to trot that one out :wink: So I’m building dimensions atop my Vault, and I want to build PiTs for each hub that’s going into the Information Layer, but reading the DV 2.0 book has…

---

## [Multi-active data as Document SATs using dbtvault](https://forum.data-community.org/t/multi-active-data-as-document-sats-using-dbtvault/167)

<div class="topic-metadata">

**Author:** [@saqib](https://forum.data-community.org/u/saqib)\
**Replies:** 5\
**Last updated:** [February 23, 2022, 3:31am UTC](https://forum.data-community.org/t/multi-active-data-as-document-sats-using-dbtvault/167 "2022-02-23T03:31:57Z")

</div>

Hello all, @alex.higgs , thanks for the excellent overview of the dbtvault yesterday. A follow up on the Multi-active SATs. Are there any dbvault patterns/recipes for loading the multi-active data as Document SATs usi…

---

## [Business Key Size in Hubs](https://forum.data-community.org/t/business-key-size-in-hubs/305)

<div class="topic-metadata">

**Author:** [@Bigguy365](https://forum.data-community.org/u/Bigguy365)\
**Replies:** 4\
**Last updated:** [June 8, 2022, 2:48pm UTC](https://forum.data-community.org/t/business-key-size-in-hubs/305 "2022-06-08T14:48:36Z")

</div>

With passive integration, the business key that we’re encountering can be either numeric or character. The size of the business key needs to accommodate the largest known size during the initial development to avoid rev…

---

## [Need some advice modeling a store hub and satellites](https://forum.data-community.org/t/need-some-advice-modeling-a-store-hub-and-satellites/1114)

<div class="topic-metadata">

**Author:** [@k50](https://forum.data-community.org/u/k50)\
**Replies:** 3\
**Last updated:** [January 17, 2024, 12:43am UTC](https://forum.data-community.org/t/need-some-advice-modeling-a-store-hub-and-satellites/1114 "2024-01-17T00:43:39Z")

</div>

Hi, our team is fairly new to DV modeling, we have one resource with a few sparse years of experience and I have many years of modeling experience but little DV. We have a source file that provides convenience store inf…

---

## [Business Vault Training Resources](https://forum.data-community.org/t/business-vault-training-resources/978)

<div class="topic-metadata">

**Author:** [@JenniferMarek](https://forum.data-community.org/u/JenniferMarek)\
**Replies:** 5\
**Last updated:** [September 26, 2023, 10:34pm UTC](https://forum.data-community.org/t/business-vault-training-resources/978 "2023-09-26T22:34:10Z")

</div>

Hi All - have you encountered any quality resources for Business Vault training/tutorials? I’m looking for a resource that shows hands-on examples that show a clear lineage between the business requirement, raw vault o…

---

## [Hubs and dependent Hubs](https://forum.data-community.org/t/hubs-and-dependent-hubs/1242)

<div class="topic-metadata">

**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")

</div>

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 …

---

## [Loading Pre-aggregated Data into Raw Vault.](https://forum.data-community.org/t/loading-pre-aggregated-data-into-raw-vault/562)

<div class="topic-metadata">

**Author:** [@MarkyMark](https://forum.data-community.org/u/MarkyMark)\
**Replies:** 3\
**Last updated:** [February 5, 2023, 9:25pm UTC](https://forum.data-community.org/t/loading-pre-aggregated-data-into-raw-vault/562 "2023-02-05T21:25:45Z")

</div>

We have a software engineering team who help land data from various different 3rd party applications. Some of these involve API calls that return effectively the output of what would be a report in the same application. …

---

## [Indexing in SQL server and DV 2.0](https://forum.data-community.org/t/indexing-in-sql-server-and-dv-2-0/917)

<div class="topic-metadata">

**Author:** [@DVBeginner](https://forum.data-community.org/u/DVBeginner)\
**Replies:** 2\
**Last updated:** [November 4, 2023, 8:55am UTC](https://forum.data-community.org/t/indexing-in-sql-server-and-dv-2-0/917 "2023-11-04T08:55:29Z")

</div>

Hello I started testing the automatedv and found that only clustered columnstore indexes are added for all tables. Would you still add additional indexes? E g. Unique non-clustered for hash keys of hubs and links, busin…

---

## [How Does an RTS Perform Over Time With Snapshot Loads?](https://forum.data-community.org/t/how-does-an-rts-perform-over-time-with-snapshot-loads/797)

<div class="topic-metadata">

**Author:** [@j\_good](https://forum.data-community.org/u/j_good)\
**Replies:** 2\
**Last updated:** [May 21, 2023, 11:03pm UTC](https://forum.data-community.org/t/how-does-an-rts-perform-over-time-with-snapshot-loads/797 "2023-05-21T23:03:13Z")

</div>

On the auditing side of things, we want to see when items are deleted. I read Cuba’s “Data Vault’s New Hero” post about RTS and XTS. Do I understand correctly that in an RTS, you’re recording the state on every load? …

---

## [Self Join Scenario](https://forum.data-community.org/t/self-join-scenario/1543)

<div class="topic-metadata">

**Author:** [@kvs.naidu](https://forum.data-community.org/u/kvs.naidu)\
**Replies:** 3\
**Last updated:** [October 20, 2024, 11:17pm UTC](https://forum.data-community.org/t/self-join-scenario/1543 "2024-10-20T23:17:21Z")

</div>

Hai, I have a table which references with itself know as self join. I have an employee table where emp\_id is primary key. another column called manager\_id which is referencing to emp\_id only. becoz manager also employe…

---

## [Two LINKs that are are different grain between the same HUBs?](https://forum.data-community.org/t/two-links-that-are-are-different-grain-between-the-same-hubs/232)

<div class="topic-metadata">

**Author:** [@saqib](https://forum.data-community.org/u/saqib)\
**Replies:** 5\
**Last updated:** [April 15, 2022, 3:10pm UTC](https://forum.data-community.org/t/two-links-that-are-are-different-grain-between-the-same-hubs/232 "2022-04-15T15:10:05Z")

</div>

Hello, Is it okay to have one than one LINK between the same HUBs? We have situation where we need the LINKs to be at two different grains: One at the LINE ITEM level called LINK\_ORDER\_LINE\_ITEM\_NODE One at the LINE I…

---

## [What would be the data vault of this data model?](https://forum.data-community.org/t/what-would-be-the-data-vault-of-this-data-model/580)

<div class="topic-metadata">

**Author:** [@BilalNadeem25](https://forum.data-community.org/u/BilalNadeem25)\
**Replies:** 2\
**Last updated:** [February 8, 2023, 10:02pm UTC](https://forum.data-community.org/t/what-would-be-the-data-vault-of-this-data-model/580 "2023-02-08T22:02:26Z")

</div>

Hello! This is a data model involving four tables: Employees, QA, QAStrategy and ProfessionalServices. The QA table has a composite key formed by its primary key and two primary keys that are coming from Employees as …

---

## [What to Do When Your Org Deviates from the Standard](https://forum.data-community.org/t/what-to-do-when-your-org-deviates-from-the-standard/237)

<div class="topic-metadata">

**Author:** [@Nicruzer](https://forum.data-community.org/u/Nicruzer)\
**Replies:** 5\
**Last updated:** [November 30, 2022, 9:02am UTC](https://forum.data-community.org/t/what-to-do-when-your-org-deviates-from-the-standard/237 "2022-11-30T09:02:24Z")

</div>

I initially learned about Data Vault on the team where I currently work, and that ultimately led me to the obsession I have today with this “system of business intelligence,” including pursuing the practitioner certifica…

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

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