# Latest **URL:** https://forum.data-community.org/latest.md?page=4 [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:** 5 --- ## [Splitting the satellite in Business Vault](https://forum.data-community.org/t/splitting-the-satellite-in-business-vault/1577)
**Author:** [@NK0206](https://forum.data-community.org/u/NK0206)\ **Replies:** 2\ **Last updated:** [November 7, 2024, 9:43pm UTC](https://forum.data-community.org/t/splitting-the-satellite-in-business-vault/1577 "2024-11-07T21:43:31Z")
Hello , In a Use case We have data coming from 20+ sources which will be loaded into the RDV as Separate source driven satellites, so 20 Source feeds will load 20 different Satellites . Next , we are divided on the… --- ## [Link DCK or MA satellite for modelling role/type information](https://forum.data-community.org/t/link-dck-or-ma-satellite-for-modelling-role-type-information/1576)
**Author:** [@mrjovana](https://forum.data-community.org/u/mrjovana)\ **Replies:** 1\ **Last updated:** [November 7, 2024, 9:32pm UTC](https://forum.data-community.org/t/link-dck-or-ma-satellite-for-modelling-role-type-information/1576 "2024-11-07T21:32:37Z")
Hey guys. Do you have any suggestions on right approach to model multiple possible values for role or type info for a specific link? For example, A and B customers are related with relationship types “parent” and “payer… --- ## [Best Practices for Liquibase Folder Structure with Data Vault Modeling](https://forum.data-community.org/t/best-practices-for-liquibase-folder-structure-with-data-vault-modeling/1565)
**Author:** [@tg3](https://forum.data-community.org/u/tg3)\ **Replies:** 3\ **Last updated:** [October 26, 2024, 8:49pm UTC](https://forum.data-community.org/t/best-practices-for-liquibase-folder-structure-with-data-vault-modeling/1565 "2024-10-26T20:49:00Z")
I’m working on a Data Vault project and using Liquibase for version control. As Data Vault requires a significant number of tables, views, and other database objects, I’m trying to establish a clean and scalable folder s… --- ## [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 & … --- ## [How to merge the same entity from another sources](https://forum.data-community.org/t/how-to-merge-the-same-entity-from-another-sources/1523)
**Author:** [@Red](https://forum.data-community.org/u/Red)\ **Replies:** 4\ **Last updated:** [October 23, 2024, 12:31am UTC](https://forum.data-community.org/t/how-to-merge-the-same-entity-from-another-sources/1523 "2024-10-23T00:31:57Z")
Hi. Couldn’t find an answer in other threads, would appreciate advice and help. I am starting to update my data model using Data Vault approach and dbtvault. I am facing a situation where the same business entity (table… --- ## [Tracking attributes in a link ](https://forum.data-community.org/t/tracking-attributes-in-a-link/1552)
**Author:** [@CuriousMind](https://forum.data-community.org/u/CuriousMind)\ **Replies:** 4\ **Last updated:** [October 22, 2024, 8:28am UTC](https://forum.data-community.org/t/tracking-attributes-in-a-link/1552 "2024-10-22T08:28:31Z")
Hi All, I have a link in which relationship\_type(parent,child)is a primary key along with hub hash Keys. It also has relationship\_start\_date and relationship\_end\_date . Can I only add relationship\_start\_date and relati… --- ## [Self Join Scenario](https://forum.data-community.org/t/self-join-scenario/1543)
**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")
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… --- ## [How to convert Unix seconds to date type in staging macro ](https://forum.data-community.org/t/how-to-convert-unix-seconds-to-date-type-in-staging-macro/1553)
**Author:** [@CuriousMind](https://forum.data-community.org/u/CuriousMind)\ **Replies:** 1\ **Last updated:** [October 15, 2024, 9:42am UTC](https://forum.data-community.org/t/how-to-convert-unix-seconds-to-date-type-in-staging-macro/1553 "2024-10-15T09:42:04Z")
Hi , I want to convert Unix seconds like (12345678)format to date YYYY-MM-DD in staging macro . I am using bigquery with automatedv --- ## [Building Data Products](https://forum.data-community.org/t/building-data-products/1547)
**Author:** [@Tai](https://forum.data-community.org/u/Tai)\ **Replies:** 1\ **Last updated:** [October 14, 2024, 7:47am UTC](https://forum.data-community.org/t/building-data-products/1547 "2024-10-14T07:47:04Z")
Hello everybody, I am building Data Products based on Data Vault. I would like to generate some kind of patterns for building Data Marts in order to parameterize the way in which my Data Product searches for information … --- ## [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… --- ## [Historized or non-historized link?](https://forum.data-community.org/t/historized-or-non-historized-link/1541)
**Author:** [@DVBeginner](https://forum.data-community.org/u/DVBeginner)\ **Replies:** 3\ **Last updated:** [October 8, 2024, 9:18pm UTC](https://forum.data-community.org/t/historized-or-non-historized-link/1541 "2024-10-08T21:18:05Z")
Hi, I have following use case. There is DebitAndCredit data sourced from 2 systems. Unit Of Work is Period, AccountingSegment, AccountingDocument. Financial attributes are Debit and Credit values. First system deliv… --- ## [Azure SQL / SQL Server Table Partitioning Strategies](https://forum.data-community.org/t/azure-sql-sql-server-table-partitioning-strategies/1535)
**Author:** [@JeremyBrockman](https://forum.data-community.org/u/JeremyBrockman)\ **Replies:** 1\ **Last updated:** [September 30, 2024, 6:09pm UTC](https://forum.data-community.org/t/azure-sql-sql-server-table-partitioning-strategies/1535 "2024-09-30T18:09:46Z")
Does any one have any strategies for partitioning link and satellites in Azure SQL / SQL server I have a link / satellite pair with 132 million rows. I would use the load date, but I am loading the data from historical … --- ## [Split or consolidate hubs?](https://forum.data-community.org/t/split-or-consolidate-hubs/1427)
**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")
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… --- ## [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 --- ## [Using json to hash diff your satllite](https://forum.data-community.org/t/using-json-to-hash-diff-your-satllite/1520)
**Author:** [@turagittech](https://forum.data-community.org/u/turagittech)\ **Replies:** 3\ **Last updated:** [September 23, 2024, 2:28am UTC](https://forum.data-community.org/t/using-json-to-hash-diff-your-satllite/1520 "2024-09-23T02:28:55Z")
Hi All, This one is for some who might be looking for ways to hash dif with large numbers if columns in source tables and/or dealing with varchar(max). Now I can’t claim any ownership of the solution beyond deciding to … --- ## [How do you document your Data Vault design?](https://forum.data-community.org/t/how-do-you-document-your-data-vault-design/1465)
**Author:** [@JeremyBrockman](https://forum.data-community.org/u/JeremyBrockman)\ **Replies:** 3\ **Last updated:** [September 19, 2024, 1:30pm UTC](https://forum.data-community.org/t/how-do-you-document-your-data-vault-design/1465 "2024-09-19T13:30:14Z")
I am working on an increasingly complicated Data Vault and docmentation is starting to become more and more clumbersome. I was wondering how other people are doing it. I have been using Figma to create a visual represe… --- ## [FlightLink in Data Vault by Dan Linstedt ](https://forum.data-community.org/t/flightlink-in-data-vault-by-dan-linstedt/1508)
**Author:** [@KamranValijonov](https://forum.data-community.org/u/KamranValijonov)\ **Replies:** 2\ **Last updated:** [September 18, 2024, 3:46pm UTC](https://forum.data-community.org/t/flightlink-in-data-vault-by-dan-linstedt/1508 "2024-09-18T15:46:02Z")
Hi there! I’ve been documenting my learnings for each concept in Data Vault 2.0 book by Dan Linstedt and came across the Link Driving Key topic in chapter 4.5.5 (page 140). It describes that in the context of flight, t… --- ## [Need help with a data vault model](https://forum.data-community.org/t/need-help-with-a-data-vault-model/1513)
**Author:** [@dvneedshelp](https://forum.data-community.org/u/dvneedshelp)\ **Replies:** 1\ **Last updated:** [September 18, 2024, 3:44pm UTC](https://forum.data-community.org/t/need-help-with-a-data-vault-model/1513 "2024-09-18T15:44:29Z")
Hey everyone, I have been trying for some time now to model our source data into a data vault. Overall, I would say I am reasonably accustomed to the data vault artefacts and have read up on data vault by using the “sca… --- ## [data vault modeling : staging layer](https://forum.data-community.org/t/data-vault-modeling-staging-layer/1509)
**Author:** [@Heskarioth](https://forum.data-community.org/u/Heskarioth)\ **Replies:** 5\ **Last updated:** [September 18, 2024, 3:41pm UTC](https://forum.data-community.org/t/data-vault-modeling-staging-layer/1509 "2024-09-18T15:41:30Z")
Hi everyone, I am fairly new to Data Vault, I’ve done some reading online and tried to learn as much as possible. I was asked by my company to review an existing data vault implementation an ex colleague has developed. … --- ## [Bridge pseudo code](https://forum.data-community.org/t/bridge-pseudo-code/637)
**Author:** [@FrenkLoonen](https://forum.data-community.org/u/FrenkLoonen)\ **Replies:** 10\ **Last updated:** [September 9, 2024, 8:48am UTC](https://forum.data-community.org/t/bridge-pseudo-code/637 "2024-09-09T08:48:21Z")
Hi all, I’m looking to implement my first bridge table using dbtvault. I looked up @patrickcuba pseudo code, but unfortunately, that doesn’t cover effectivity satellites. So I have a Hub (called “hub”), with two Links … --- ## [Handle Multi-Value](https://forum.data-community.org/t/handle-multi-value/1469)
**Author:** [@Datavault4u](https://forum.data-community.org/u/Datavault4u)\ **Replies:** 1\ **Last updated:** [August 19, 2024, 12:03pm UTC](https://forum.data-community.org/t/handle-multi-value/1469 "2024-08-19T12:03:31Z")
Looking for recommendations on handling multi-value attributes data in RDV? --- ## [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)
**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")
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… --- ## [Data quality, data checks](https://forum.data-community.org/t/data-quality-data-checks/1107)
**Author:** [@Nikola](https://forum.data-community.org/u/Nikola)\ **Replies:** 5\ **Last updated:** [August 13, 2024, 10:49pm UTC](https://forum.data-community.org/t/data-quality-data-checks/1107 "2024-08-13T22:49:29Z")
Hello all! I couldn’t find any post here regarding the data quality checks in a Data Vault. I’working on this issue currentky and, so far, I implemented data reconciliation an hash comparison. I’m interested in extend… --- ## [How to model list attribute](https://forum.data-community.org/t/how-to-model-list-attribute/1462)
**Author:** [@artt](https://forum.data-community.org/u/artt)\ **Replies:** 2\ **Last updated:** [August 12, 2024, 4:05am UTC](https://forum.data-community.org/t/how-to-model-list-attribute/1462 "2024-08-12T04:05:47Z")
HI, I\`m trying to model the case as below. Source Table (Task ID | Attr1 | Attr2 | Countries | Products | LastModificationDate), is providing attributes for Tasks, all the attributes are single valued, except Countries … --- ## [Testing data vault](https://forum.data-community.org/t/testing-data-vault/1456)
**Author:** [@Datavault4u](https://forum.data-community.org/u/Datavault4u)\ **Replies:** 2\ **Last updated:** [August 9, 2024, 12:57pm UTC](https://forum.data-community.org/t/testing-data-vault/1456 "2024-08-09T12:57:25Z")
all, we know data vault is ever evolving thing, where we keep adding new tables to it for an rapid delivery, how will be make sure the testing is performed as expected? do we come up with regression? what is the framewor… --- ## [Business vault sat PITs](https://forum.data-community.org/t/business-vault-sat-pits/1426)
**Author:** [@Nat](https://forum.data-community.org/u/Nat)\ **Replies:** 3\ **Last updated:** [August 7, 2024, 1:04pm UTC](https://forum.data-community.org/t/business-vault-sat-pits/1426 "2024-08-07T13:04:38Z")
Hi I have a BV sat which I’m using to calculate a monthly recurring revenue from a contract table and an invoices table (so i.e. take the monthly value if the invoice period is for a month, take the contract amount / co… --- ## [Is data vault the right choice?](https://forum.data-community.org/t/is-data-vault-the-right-choice/1445)
**Author:** [@dvneedshelp](https://forum.data-community.org/u/dvneedshelp)\ **Replies:** 2\ **Last updated:** [August 4, 2024, 9:10pm UTC](https://forum.data-community.org/t/is-data-vault-the-right-choice/1445 "2024-08-04T21:10:05Z")
Hey everyone, before getting into the question in the title, I want to give some context. I recently joined a team, where Data Vault was brought in previously by a consultancy during the build up of a data warehouse. S… --- ## [How to implement hub haskey concept for same financial instrument from multiple source systems.](https://forum.data-community.org/t/how-to-implement-hub-haskey-concept-for-same-financial-instrument-from-multiple-source-systems/1444)
**Author:** [@ankitsrmscs08](https://forum.data-community.org/u/ankitsrmscs08)\ **Replies:** 1\ **Last updated:** [August 1, 2024, 12:42am UTC](https://forum.data-community.org/t/how-to-implement-hub-haskey-concept-for-same-financial-instrument-from-multiple-source-systems/1444 "2024-08-01T00:42:24Z")
Scenario : Taking about same Business Entity record coming from multiple sources. Source A sends IDENTIFIER 1 as PKEY, IDENTIFIER 2 loaded to satellite. Source B sends null IDENTIFIER 1 and sends non null IDENTIFIER 2 … --- ## [First try AutomateDV - what are the correct keys?](https://forum.data-community.org/t/first-try-automatedv-what-are-the-correct-keys/1443)
**Author:** [@datavaultmon](https://forum.data-community.org/u/datavaultmon)\ **Replies:** 1\ **Last updated:** [July 31, 2024, 9:55pm UTC](https://forum.data-community.org/t/first-try-automatedv-what-are-the-correct-keys/1443 "2024-07-31T21:55:52Z")
Hi together, I have a total noob question but we have just started testing Automate DV :leichtes\_lächeln: So, there are two staging tables involved in this, stg\_eafako and stg\_eakopf. They both have a EAFAKO\_ID and EAKO… --- ## [Adding new relationships to an existing link](https://forum.data-community.org/t/adding-new-relationships-to-an-existing-link/1442)
**Author:** [@akspande1989](https://forum.data-community.org/u/akspande1989)\ **Replies:** 1\ **Last updated:** [July 31, 2024, 9:53pm UTC](https://forum.data-community.org/t/adding-new-relationships-to-an-existing-link/1442 "2024-07-31T21:53:07Z")
Hi, I am working on a use-case where there is an existing link (between five business keys) modeled in the raw vault, and there is a plan to add a new business key to the raw source, which adds to the relationship. One … [Previous page](https://forum.data-community.org/latest.md?page=3) [Next page](https://forum.data-community.org/latest.md?page=5)