# Top

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

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

---

## [Modeling alternate ids in hub - BKCC?](https://forum.data-community.org/t/modeling-alternate-ids-in-hub-bkcc/349)

<div class="topic-metadata">

**Author:** [@malcolmhaar](https://forum.data-community.org/u/malcolmhaar)\
**Replies:** 3\
**Last updated:** [June 30, 2022, 3:23am UTC](https://forum.data-community.org/t/modeling-alternate-ids-in-hub-bkcc/349 "2022-06-30T03:23:06Z")

</div>

Let’s say I’m building a Person hub and I get a mix of ids from sources. Some of the IDs are source-specific (i.e. meaningful only within that source). Others are meaningful across sources (e.g. drivers license number, …

---

## [Dropping historical entries in a computed satellite?](https://forum.data-community.org/t/dropping-historical-entries-in-a-computed-satellite/569)

<div class="topic-metadata">

**Author:** [@mrcol](https://forum.data-community.org/u/mrcol)\
**Replies:** 5\
**Last updated:** [November 7, 2023, 6:51am UTC](https://forum.data-community.org/t/dropping-historical-entries-in-a-computed-satellite/569 "2023-11-07T06:51:40Z")

</div>

Hi everyone! I would like to load a computed satellite into a business vault but am interested only in the most recent versions of the attributes for each business key. Is it OK from the DV2.0 standard perspective, not…

---

## [How to determine if a unique hub/satelite is needed](https://forum.data-community.org/t/how-to-determine-if-a-unique-hub-satelite-is-needed/975)

<div class="topic-metadata">

**Author:** [@k50](https://forum.data-community.org/u/k50)\
**Replies:** 5\
**Last updated:** [November 2, 2023, 6:11am UTC](https://forum.data-community.org/t/how-to-determine-if-a-unique-hub-satelite-is-needed/975 "2023-11-02T06:11:52Z")

</div>

Am new to DataVault, our DV architect is vaulting product information. we get a flat product file from our source system. one of the attributes is the manufacturer name. ie Coke, Pepsi, etc. thats all we get, no othe…

---

## [PII value is being used for Business Key](https://forum.data-community.org/t/pii-value-is-being-used-for-business-key/565)

<div class="topic-metadata">

**Author:** [@jheckman324](https://forum.data-community.org/u/jheckman324)\
**Replies:** 6\
**Last updated:** [July 3, 2023, 10:04pm UTC](https://forum.data-community.org/t/pii-value-is-being-used-for-business-key/565 "2023-07-03T22:04:21Z")

</div>

We are modeling a healthcare data vault in which members will eventually need to be matched to claimed by business analysts. Legal/Compliance has just informed us that the MemberId field on the member records are PII be…

---

## [Dealing with NVARCHAR(MAX) Columns in Hash Calculations Azure Synapse DB](https://forum.data-community.org/t/dealing-with-nvarchar-max-columns-in-hash-calculations-azure-synapse-db/743)

<div class="topic-metadata">

**Author:** [@Bigguy365](https://forum.data-community.org/u/Bigguy365)\
**Replies:** 5\
**Last updated:** [April 12, 2023, 2:28pm UTC](https://forum.data-community.org/t/dealing-with-nvarchar-max-columns-in-hash-calculations-azure-synapse-db/743 "2023-04-12T14:28:08Z")

</div>

In a satellite table, I have a column that contains descriptive information in the form of string paragraphs. The largest length of this column is 39,467. I’m stuck in how to specify the value into a hash calculation whe…

---

## [How to do 100% insert only soft delete? (Record Source Tracking)](https://forum.data-community.org/t/how-to-do-100-insert-only-soft-delete-record-source-tracking/513)

<div class="topic-metadata">

**Author:** [@sosmaf](https://forum.data-community.org/u/sosmaf)\
**Replies:** 3\
**Last updated:** [November 24, 2022, 10:36pm UTC](https://forum.data-community.org/t/how-to-do-100-insert-only-soft-delete-record-source-tracking/513 "2022-11-24T22:36:15Z")

</div>

Let’s say we need to soft delete business keys that do not appear for 4 consequent weeks in the source and we use a some sort of “Deleted Status Satellite”. How can we mark the status of the keys that do not appear in t…

---

## [Data Vault Database schema](https://forum.data-community.org/t/data-vault-database-schema/651)

<div class="topic-metadata">

**Author:** [@Nikunj](https://forum.data-community.org/u/Nikunj)\
**Replies:** 6\
**Last updated:** [March 8, 2023, 9:40pm UTC](https://forum.data-community.org/t/data-vault-database-schema/651 "2023-03-08T21:40:07Z")

</div>

Would like to seek guidance on how do you go about separating different layers of data vault in database schemas? Schema names such as STG.\<\> for staging tables RV.\<\> for raw vault BV.\<\> for business vault IM.\<\> for…

---

## [How to Integrate Same-As-Links into PITs](https://forum.data-community.org/t/how-to-integrate-same-as-links-into-pits/422)

<div class="topic-metadata">

**Author:** [@Nicruzer](https://forum.data-community.org/u/Nicruzer)\
**Replies:** 5\
**Last updated:** [August 18, 2023, 8:55am UTC](https://forum.data-community.org/t/how-to-integrate-same-as-links-into-pits/422 "2023-08-18T08:55:49Z")

</div>

We are currently integrating 2 source systems for employee information where the second source system contains many of the employees from the original source system. The business key in the 2nd system prepends the “emplo…

---

## [Data Mesh - and what it bodes for Data Vault in the future](https://forum.data-community.org/t/data-mesh-and-what-it-bodes-for-data-vault-in-the-future/251)

<div class="topic-metadata">

**Author:** [@jhall\_uk](https://forum.data-community.org/u/jhall_uk)\
**Replies:** 7\
**Last updated:** [August 3, 2022, 10:26pm UTC](https://forum.data-community.org/t/data-mesh-and-what-it-bodes-for-data-vault-in-the-future/251 "2022-08-03T22:26:00Z")

</div>

Hi all, There seems to be quite a bit of buzz around Data Mesh and the concepts of delivering data products as API driven services. Zhamak Dehghani has been talking about this concept in the wider IT industry and has pu…

---

## [Use Date as Dependent Child (Forecasts, historical data)](https://forum.data-community.org/t/use-date-as-dependent-child-forecasts-historical-data/867)

<div class="topic-metadata">

**Author:** [@Chris](https://forum.data-community.org/u/Chris)\
**Replies:** 2\
**Last updated:** [June 29, 2023, 2:57pm UTC](https://forum.data-community.org/t/use-date-as-dependent-child-forecasts-historical-data/867 "2023-06-29T14:57:37Z")

</div>

Hi, are there any best practices for modelling transactions or forecast without a transaction-ID (Sales-ID, Order-ID,…) suitable as BK. I came across some sources providing data like this (filebased or database tables)…

---

## [Handling "Expected" Duplicates](https://forum.data-community.org/t/handling-expected-duplicates/1078)

<div class="topic-metadata">

**Author:** [@ronny214](https://forum.data-community.org/u/ronny214)\
**Replies:** 4\
**Last updated:** [December 6, 2023, 1:44am UTC](https://forum.data-community.org/t/handling-expected-duplicates/1078 "2023-12-06T01:44:29Z")

</div>

More Salesforce woes when it comes to DV… There are many instances where a record in Salesforce gets “touched” but not necessarily a data update and, because of the nature of Salesforce, the LastModifiedDate gets update…

---

## [How to Implement Hard and Soft Rules](https://forum.data-community.org/t/how-to-implement-hard-and-soft-rules/247)

<div class="topic-metadata">

**Author:** [@Bigguy365](https://forum.data-community.org/u/Bigguy365)\
**Replies:** 4\
**Last updated:** [April 23, 2022, 11:55am UTC](https://forum.data-community.org/t/how-to-implement-hard-and-soft-rules/247 "2022-04-23T11:55:50Z")

</div>

In learning about the data vault methodology, the topics of hard rules and soft rules are mentioned to identify the “WHAT” specific transformations to the data NEEDS to be completed before loading the data into the raw v…

---

## [The dbtvault Data Vault automation tool](https://forum.data-community.org/t/the-dbtvault-data-vault-automation-tool/244)

<div class="topic-metadata">

**Author:** [@Bigguy365](https://forum.data-community.org/u/Bigguy365)\
**Replies:** 4\
**Last updated:** [April 20, 2022, 1:43pm UTC](https://forum.data-community.org/t/the-dbtvault-data-vault-automation-tool/244 "2022-04-20T13:43:01Z")

</div>

This tool has piqued my interest to dig in and understand how it works and how to use it. I watched the new feature video and looked up in the history of posts and only found 1 dealing with its usage – (How do I build t…

---

## [How to model an empty list in multi-active satellite?](https://forum.data-community.org/t/how-to-model-an-empty-list-in-multi-active-satellite/428)

<div class="topic-metadata">

**Author:** [@mrcol](https://forum.data-community.org/u/mrcol)\
**Replies:** 7\
**Last updated:** [September 19, 2022, 7:51am UTC](https://forum.data-community.org/t/how-to-model-an-empty-list-in-multi-active-satellite/428 "2022-09-19T07:51:42Z")

</div>

Hi all, I have a source system where one of the attributes of a business object is represented as a JSON array of strings (labels), e.g., \[“label1”, “label2”, “label3”\]. Over time (t), new labels can be added or remo…

---

## [One or More Hubs for same Entity](https://forum.data-community.org/t/one-or-more-hubs-for-same-entity/950)

<div class="topic-metadata">

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

</div>

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 …

---

## [Handling relationship between parties in Data Vault](https://forum.data-community.org/t/handling-relationship-between-parties-in-data-vault/1026)

<div class="topic-metadata">

**Author:** [@Swaminathan](https://forum.data-community.org/u/Swaminathan)\
**Replies:** 7\
**Last updated:** [January 3, 2024, 10:11am UTC](https://forum.data-community.org/t/handling-relationship-between-parties-in-data-vault/1026 "2024-01-03T10:11:53Z")

</div>

Hello All In my current project, I am facing an issue related to handling the relationship between parties in Data Vault. I need to model to cater the below requirement. There are two parties - Party (customer) 1, Pa…

---

## [Tracking number of INSERTs into HUB, LINK and Satellite](https://forum.data-community.org/t/tracking-number-of-inserts-into-hub-link-and-satellite/116)

<div class="topic-metadata">

**Author:** [@saqib](https://forum.data-community.org/u/saqib)\
**Replies:** 6\
**Last updated:** [January 29, 2022, 6:05pm UTC](https://forum.data-community.org/t/tracking-number-of-inserts-into-hub-link-and-satellite/116 "2022-01-29T18:05:00Z")

</div>

Hello, We have audit requirement to capture the INSERT for each HUB, LINK and SAT. Currently I have implemented a python wrapper that performs the update of the DV as one single Snowflake transaction. This python wrappe…

---

## [Loading of Historical Snapshots Data Into a Data Vault 2.0](https://forum.data-community.org/t/loading-of-historical-snapshots-data-into-a-data-vault-2-0/951)

<div class="topic-metadata">

**Author:** [@luissimoes](https://forum.data-community.org/u/luissimoes)\
**Replies:** 5\
**Last updated:** [August 28, 2023, 8:12am UTC](https://forum.data-community.org/t/loading-of-historical-snapshots-data-into-a-data-vault-2-0/951 "2023-08-28T08:12:27Z")

</div>

Hi Everyone! I have been asked to create a data vault 2.0 model based on a historical dataset that contains snapshots of data since 5 years ago. I would like to know if there is any good approach to the initial load of…

---

## [Non-historized or normal link](https://forum.data-community.org/t/non-historized-or-normal-link/740)

<div class="topic-metadata">

**Author:** [@Zwiebel](https://forum.data-community.org/u/Zwiebel)\
**Replies:** 6\
**Last updated:** [April 16, 2023, 11:29pm UTC](https://forum.data-community.org/t/non-historized-or-normal-link/740 "2023-04-16T23:29:20Z")

</div>

Hi all, We receive transactional data from the source. It’s a big table (not that many columns but many rows) and the transactional value for the last months could be updated from the source. Since the source data coul…

---

## [Tracking status for a dependent child data](https://forum.data-community.org/t/tracking-status-for-a-dependent-child-data/337)

<div class="topic-metadata">

**Author:** [@mloghin](https://forum.data-community.org/u/mloghin)\
**Replies:** 4\
**Last updated:** [July 8, 2022, 11:31am UTC](https://forum.data-community.org/t/tracking-status-for-a-dependent-child-data/337 "2022-07-08T11:31:43Z")

</div>

I have a Hub and a Sat with dependent child key (generated sequence). I need to track changes at the dep-key level. The change status is not managed at the source, but it is possible to infer what happened to a dep-key p…

---

## [How should I model Customer/Invoice relationship?](https://forum.data-community.org/t/how-should-i-model-customer-invoice-relationship/1702)

<div class="topic-metadata">

**Author:** [@christobo](https://forum.data-community.org/u/christobo)\
**Replies:** 3\
**Last updated:** [February 4, 2025, 2:07am UTC](https://forum.data-community.org/t/how-should-i-model-customer-invoice-relationship/1702 "2025-02-04T02:07:02Z")

</div>

Hi all! This seems like a simple and common situation but we’re struggling with the right way to do it. We have a customer hub, and an invoice header hub. Invoices are linked to customers, and invoices come from multiple…

---

## [Linking User Hub to Numerous Other Hubs By CreatedBy/LastModifiedBy](https://forum.data-community.org/t/linking-user-hub-to-numerous-other-hubs-by-createdby-lastmodifiedby/92)

<div class="topic-metadata">

**Author:** [@gnewsham](https://forum.data-community.org/u/gnewsham)\
**Replies:** 7\
**Last updated:** [June 22, 2022, 2:01pm UTC](https://forum.data-community.org/t/linking-user-hub-to-numerous-other-hubs-by-createdby-lastmodifiedby/92 "2022-06-22T14:01:44Z")

</div>

Many tables in many sources have audit columns that includes an id of a user who created and/or last modified the record, with the id linking to a separate table of Users. My data analysts would like this audit data I …

---

## [Data Vault Certification](https://forum.data-community.org/t/data-vault-certification/413)

<div class="topic-metadata">

**Author:** [@longrob604](https://forum.data-community.org/u/longrob604)\
**Replies:** 3\
**Last updated:** [September 2, 2022, 3:52pm UTC](https://forum.data-community.org/t/data-vault-certification/413 "2022-09-02T15:52:58Z")

</div>

Hi there I have been looking into CDVP2 certification which seems to be well-regarded. However I couldn’t find information about how to register for the exam, without having to pay $3k+ for a training course first. Sure…

---

## [Handling erroneous input data](https://forum.data-community.org/t/handling-erroneous-input-data/686)

<div class="topic-metadata">

**Author:** [@DVBeginner](https://forum.data-community.org/u/DVBeginner)\
**Replies:** 8\
**Last updated:** [March 14, 2023, 11:41am UTC](https://forum.data-community.org/t/handling-erroneous-input-data/686 "2023-03-14T11:41:40Z")

</div>

Hi, I read many times that we good, bad and ugly data should be loaded to raw vault and then handled via business rules, but is always practical? What if there is 1 row of bad data in the source system, that cannot be …

---

## [How to distinguish between a business key or standard satellite attribute](https://forum.data-community.org/t/how-to-distinguish-between-a-business-key-or-standard-satellite-attribute/1136)

<div class="topic-metadata">

**Author:** [@k50](https://forum.data-community.org/u/k50)\
**Replies:** 5\
**Last updated:** [January 30, 2024, 12:44pm UTC](https://forum.data-community.org/t/how-to-distinguish-between-a-business-key-or-standard-satellite-attribute/1136 "2024-01-30T12:44:21Z")

</div>

We are pulling a list of stores from our ERP system. In the ERP system, there is a single table for stores. Some of the attributes are: Address (multiple fields) Store Size (S, M, L, XL) - these have lookups in the E…

---

## [Code template to use effectivity satellites for multiple sources](https://forum.data-community.org/t/code-template-to-use-effectivity-satellites-for-multiple-sources/957)

<div class="topic-metadata">

**Author:** [@DVBeginner](https://forum.data-community.org/u/DVBeginner)\
**Replies:** 8\
**Last updated:** [September 4, 2023, 8:07pm UTC](https://forum.data-community.org/t/code-template-to-use-effectivity-satellites-for-multiple-sources/957 "2023-09-04T20:07:52Z")

</div>

Hi, We have stumbled upon following challange: We have identified multiple links, where there is a driving key and relation to other hubs can change over time. We have introduced multiple effectivity satellite in orde…

---

## [DV2 Naming Standards](https://forum.data-community.org/t/dv2-naming-standards/367)

<div class="topic-metadata">

**Author:** [@JanetMcF](https://forum.data-community.org/u/JanetMcF)\
**Replies:** 2\
**Last updated:** [July 21, 2022, 10:22pm UTC](https://forum.data-community.org/t/dv2-naming-standards/367 "2022-07-21T22:22:13Z")

</div>

Is there a document out there somewhere that has the naming standards for DV2 objects? Thanks, Janet

---

## [CRM Data Vault Model](https://forum.data-community.org/t/crm-data-vault-model/1033)

<div class="topic-metadata">

**Author:** [@Swaminathan](https://forum.data-community.org/u/Swaminathan)\
**Replies:** 6\
**Last updated:** [January 12, 2024, 3:04pm UTC](https://forum.data-community.org/t/crm-data-vault-model/1033 "2024-01-12T15:04:01Z")

</div>

Hello all Have been searching for sample data vault model on CRM. Similar kind of implementation is required in one of the projects. But I could not find anything useful. Could you please point me to some links ? Than…

---

## [data vault modeling : staging layer](https://forum.data-community.org/t/data-vault-modeling-staging-layer/1509)

<div class="topic-metadata">

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

</div>

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. …

---

## [Top 10 Worst IT technologies](https://forum.data-community.org/t/top-10-worst-it-technologies/290)

<div class="topic-metadata">

**Author:** [@alex.higgs](https://forum.data-community.org/u/alex.higgs)\
**Replies:** 3\
**Last updated:** [May 28, 2022, 12:59pm UTC](https://forum.data-community.org/t/top-10-worst-it-technologies/290 "2022-05-28T12:59:32Z")

</div>

At the WWDVC 2022, Dan Linstedt joked for someone to come up with the top 10 Worst technologies/approaches/things. This was in the context of XML being at least #5 Here are a few initial proposals: XML JavaScript PHP …

---

## [How do i build the Business Vault with dbtvault?](https://forum.data-community.org/t/how-do-i-build-the-business-vault-with-dbtvault/35)

<div class="topic-metadata">

**Author:** [@johnoscott](https://forum.data-community.org/u/johnoscott)\
**Replies:** 2\
**Last updated:** [December 7, 2021, 7:20pm UTC](https://forum.data-community.org/t/how-do-i-build-the-business-vault-with-dbtvault/35 "2021-12-07T19:20:57Z")

</div>

How does one go about implementing a Business Vault using dbtvault ? I have some business (soft) rules that can be nicely implemented as dbt models but I am wondering how they should be configured and orchestrated.

---

## [Modeling Functional Roles](https://forum.data-community.org/t/modeling-functional-roles/339)

<div class="topic-metadata">

**Author:** [@Nicruzer](https://forum.data-community.org/u/Nicruzer)\
**Replies:** 6\
**Last updated:** [July 7, 2022, 6:09am UTC](https://forum.data-community.org/t/modeling-functional-roles/339 "2022-07-07T06:09:05Z")

</div>

This image represents how we handle functional roles in our access control system. A functional role is a set of accesses created to simplify the provisioning/deprovisioning process such that a resource need only subm…

---

## [Crowd Sourcing: Best Practice in Dimensional Modeling on top of DV](https://forum.data-community.org/t/crowd-sourcing-best-practice-in-dimensional-modeling-on-top-of-dv/1016)

<div class="topic-metadata">

**Author:** [@talenodigital](https://forum.data-community.org/u/talenodigital)\
**Replies:** 4\
**Last updated:** [October 27, 2023, 11:24pm UTC](https://forum.data-community.org/t/crowd-sourcing-best-practice-in-dimensional-modeling-on-top-of-dv/1016 "2023-10-27T23:24:26Z")

</div>

Hello :wave: Looking for a resource on best practices in building a Dimensional Model on top of a Data Vault. Any form of resources are welcome. Thanks! :pray:

---

## [Including additional keys as primary keys in satellite](https://forum.data-community.org/t/including-additional-keys-as-primary-keys-in-satellite/1207)

<div class="topic-metadata">

**Author:** [@Swaminathan](https://forum.data-community.org/u/Swaminathan)\
**Replies:** 3\
**Last updated:** [March 10, 2024, 3:47am UTC](https://forum.data-community.org/t/including-additional-keys-as-primary-keys-in-satellite/1207 "2024-03-10T03:47:32Z")

</div>

Hello All We are having a scenario where we need to include additional columns as primary key columns in the satellite. Kindly share your suggestion to circumvent this problem. Customer - Hub has the primary key as c…

---

## [Create End Date time in Satellites without windows function](https://forum.data-community.org/t/create-end-date-time-in-satellites-without-windows-function/1245)

<div class="topic-metadata">

**Author:** [@Venkat](https://forum.data-community.org/u/Venkat)\
**Replies:** 1\
**Last updated:** [April 10, 2024, 7:14am UTC](https://forum.data-community.org/t/create-end-date-time-in-satellites-without-windows-function/1245 "2024-04-10T07:14:48Z")

</div>

Hi We are using Data Vault 2.0 on snowflake. Created Satellite (S0) without eff\_end\_date and created view over S0 satellite with eff\_end\_date using windows function (LEAD). When querying from Info\_mart, it is becomin…

---

## [Reason for Record Source Column in Link tables](https://forum.data-community.org/t/reason-for-record-source-column-in-link-tables/567)

<div class="topic-metadata">

**Author:** [@Bigguy365](https://forum.data-community.org/u/Bigguy365)\
**Replies:** 4\
**Last updated:** [January 24, 2023, 7:26pm UTC](https://forum.data-community.org/t/reason-for-record-source-column-in-link-tables/567 "2023-01-24T19:26:22Z")

</div>

This may be a Data Vault 2.0 (101) question that I haven’t found an answer to. What is the record source column used for in links when only hubs can be used in them and the hubs have the record source info? Thank you C…

---

## [How to model inventory in an ERP](https://forum.data-community.org/t/how-to-model-inventory-in-an-erp/158)

<div class="topic-metadata">

**Author:** [@Nat](https://forum.data-community.org/u/Nat)\
**Replies:** 5\
**Last updated:** [February 9, 2022, 10:32pm UTC](https://forum.data-community.org/t/how-to-model-inventory-in-an-erp/158 "2022-02-09T22:32:14Z")

</div>

Hi Hope you can help We’re trying to model inventory in a (number of) warehouses in data vault. Each inventory position is based on a SKU, a batch numnber, a location (for example a warehouse or a transportation route…

---

## [SAP system to Data vault](https://forum.data-community.org/t/sap-system-to-data-vault/615)

<div class="topic-metadata">

**Author:** [@Nikunj](https://forum.data-community.org/u/Nikunj)\
**Replies:** 2\
**Last updated:** [February 19, 2023, 5:43pm UTC](https://forum.data-community.org/t/sap-system-to-data-vault/615 "2023-02-19T17:43:34Z")

</div>

Hello, we are to source data from a SAP ERP system. The source system just extracts the data in the raw format as it is. meaning, 100s of columns in one interface file which has technical columns inside. the column name…

---

## [Articles from https://danlinstedt.com/allposts/](https://forum.data-community.org/t/articles-from-https-danlinstedt-com-allposts/521)

<div class="topic-metadata">

**Author:** [@Nikunj](https://forum.data-community.org/u/Nikunj)\
**Replies:** 3\
**Last updated:** [December 5, 2022, 3:10pm UTC](https://forum.data-community.org/t/articles-from-https-danlinstedt-com-allposts/521 "2022-12-05T15:10:00Z")

</div>

Does anyone know where all posts from https://danlinstedt.com/allposts/ are moved to? I am unable to find these posts and they were quite useful for reference at times

---

## [To subtype or not](https://forum.data-community.org/t/to-subtype-or-not/494)

<div class="topic-metadata">

**Author:** [@jbo](https://forum.data-community.org/u/jbo)\
**Replies:** 8\
**Last updated:** [November 16, 2022, 9:39pm UTC](https://forum.data-community.org/t/to-subtype-or-not/494 "2022-11-16T21:39:14Z")

</div>

Hello, I have the following case in our company. Our business users talk about orders, invoices, credit notes, returns, etc. and so I am tempted to model these as individual entities (HUBs). However, all these entities…

---

## [Why your data architecture is holding your AI back](https://forum.data-community.org/t/why-your-data-architecture-is-holding-your-ai-back/2092)

<div class="topic-metadata">

**Author:** [@JulienRedmond](https://forum.data-community.org/u/JulienRedmond)\
**Replies:** 0\
**Last updated:** [April 30, 2026, 9:11am UTC](https://forum.data-community.org/t/why-your-data-architecture-is-holding-your-ai-back/2092 "2026-04-30T09:11:11Z")

</div>

We recently put this together based on what we’re seeing across a number of AI projects. A common pattern is that it’s not the model that’s holding things back, it’s the structure and quality of the data underneath. If …

---

## [Same as Link for Dependent Child](https://forum.data-community.org/t/same-as-link-for-dependent-child/288)

<div class="topic-metadata">

**Author:** [@saqib](https://forum.data-community.org/u/saqib)\
**Replies:** 3\
**Last updated:** [May 21, 2022, 4:58am UTC](https://forum.data-community.org/t/same-as-link-for-dependent-child/288 "2022-05-21T04:58:51Z")

</div>

Hello all, We need to create a Same as Link for Dependent Child. Since dependent child are not Business Key and they only exist in LINKs, here is what we were thinking for the structure of the SAL: HASHKEY\_1 LINE\_ITEM…

---

## [Load End Date Time in Satellites](https://forum.data-community.org/t/load-end-date-time-in-satellites/1053)

<div class="topic-metadata">

**Author:** [@Swaminathan](https://forum.data-community.org/u/Swaminathan)\
**Replies:** 3\
**Last updated:** [November 18, 2023, 3:46pm UTC](https://forum.data-community.org/t/load-end-date-time-in-satellites/1053 "2023-11-18T15:46:33Z")

</div>

Hello Team In addition to Load Date Time in satellites, do we really need to have Load End Date Time as well to sunset the old record when the new record comes in. This is different from the business start and end date…

---

## [How to create the link when linking keys are non-business keys](https://forum.data-community.org/t/how-to-create-the-link-when-linking-keys-are-non-business-keys/414)

<div class="topic-metadata">

**Author:** [@manishbhoge](https://forum.data-community.org/u/manishbhoge)\
**Replies:** 3\
**Last updated:** [September 19, 2022, 6:46am UTC](https://forum.data-community.org/t/how-to-create-the-link-when-linking-keys-are-non-business-keys/414 "2022-09-19T06:46:06Z")

</div>

Hi, I have HUB defined on the business key like: Area\_ID. However, I need to link this HUB with another HUB on a non-business key e.g. STREET\_NUMBER. How do we build the link in this scenario? Because while making the l…

---

## [Approach for handling the need for "pre-join"](https://forum.data-community.org/t/approach-for-handling-the-need-for-pre-join/685)

<div class="topic-metadata">

**Author:** [@DVBeginner](https://forum.data-community.org/u/DVBeginner)\
**Replies:** 6\
**Last updated:** [March 13, 2023, 8:13pm UTC](https://forum.data-community.org/t/approach-for-handling-the-need-for-pre-join/685 "2023-03-13T20:13:29Z")

</div>

Hi, I’ve come accross generic data sources that don’t hold business keys, but have to be joined with other structures to get to the descriptive data. For example there are Case and CaseObject tables in CRM system, that…

---

## [Raw Vault to Information Layer (Dim) Questions](https://forum.data-community.org/t/raw-vault-to-information-layer-dim-questions/997)

<div class="topic-metadata">

**Author:** [@DataDude](https://forum.data-community.org/u/DataDude)\
**Replies:** 4\
**Last updated:** [October 10, 2023, 8:45pm UTC](https://forum.data-community.org/t/raw-vault-to-information-layer-dim-questions/997 "2023-10-10T20:45:59Z")

</div>

I’ve read Linstedt’s book, but I find it light on practical details and I have some questions. For background, I’m working on a financial project with over a dozen different vendor data sources that all have various typ…

---

## [Timezone for the timestamp columns](https://forum.data-community.org/t/timezone-for-the-timestamp-columns/608)

<div class="topic-metadata">

**Author:** [@Nikunj](https://forum.data-community.org/u/Nikunj)\
**Replies:** 4\
**Last updated:** [February 15, 2023, 9:41pm UTC](https://forum.data-community.org/t/timezone-for-the-timestamp-columns/608 "2023-02-15T21:41:01Z")

</div>

Hello All, Are these any guidelines for defining which timezone the timestamp should be stored in? Using Azure SQL for the raw vault. what datetime option to choose and any considerations for the same Use datetime d…

---

## [Data vault schema evolution question](https://forum.data-community.org/t/data-vault-schema-evolution-question/1131)

<div class="topic-metadata">

**Author:** [@Mart](https://forum.data-community.org/u/Mart)\
**Replies:** 6\
**Last updated:** [January 31, 2024, 8:59am UTC](https://forum.data-community.org/t/data-vault-schema-evolution-question/1131 "2024-01-31T08:59:54Z")

</div>

Hello, I have a novice (hypothetical) question about a schema evolution scenario to gain a better understanding of how a data vault should be operated. Let’s assume I’m developing a database for the human resources depa…

---

## [Need help with complicate relationship data](https://forum.data-community.org/t/need-help-with-complicate-relationship-data/1003)

<div class="topic-metadata">

**Author:** [@sisill](https://forum.data-community.org/u/sisill)\
**Replies:** 6\
**Last updated:** [October 11, 2023, 8:25pm UTC](https://forum.data-community.org/t/need-help-with-complicate-relationship-data/1003 "2023-10-11T20:25:32Z")

</div>

Hi all I have this relationship: A hub; B hub and C hub. A is connected with B so we have A\_B\_link table and A\_B\_sat table connected to A\_B\_link. But C is depending on A-B combination. So if I must do again link table …

---

## [Skip hubs in joins](https://forum.data-community.org/t/skip-hubs-in-joins/376)

<div class="topic-metadata">

**Author:** [@abettsmp](https://forum.data-community.org/u/abettsmp)\
**Replies:** 3\
**Last updated:** [August 7, 2022, 7:38am UTC](https://forum.data-community.org/t/skip-hubs-in-joins/376 "2022-08-07T07:38:05Z")

</div>

Hi All, I’m reasonably fresh to DV but have now built a PoC DV based on dbtvault (thanks guys) and I’m now learning the joys of extracting data from the vault. The joins are getting quite extensive. I have one query (lo…

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

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