# \#satellite **URL:** https://forum.data-community.org/tag/satellite/49.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) --- ## [Business key(BK) standardisation# BK to be used for hash key creation](https://forum.data-community.org/t/business-key-bk-standardisation-bk-to-be-used-for-hash-key-creation/2171)
**Author:** [@Rupa](https://forum.data-community.org/u/Rupa)\ **Replies:** 2\ **Last updated:** [September 29, 2026, 12:12pm UTC](https://forum.data-community.org/t/business-key-bk-standardisation-bk-to-be-used-for-hash-key-creation/2171 "2026-09-29T12:12:35Z")
In this example, we are receive details of insurable entity ids from source and the records contain different levels of granularity as shown under ‘Source Data’ section. A record may represent data for content item(f… --- ## [Handling Retroactive Changes to Historical Effectivity in Data Vault 2.0](https://forum.data-community.org/t/handling-retroactive-changes-to-historical-effectivity-in-data-vault-2-0/2166)
**Author:** [@juan.jimenez](https://forum.data-community.org/u/juan.jimenez)\ **Replies:** 7\ **Last updated:** [September 23, 2026, 3:36am UTC](https://forum.data-community.org/t/handling-retroactive-changes-to-historical-effectivity-in-data-vault-2-0/2166 "2026-09-23T03:36:55Z")
Hi everyone, I completed my Data Vault 2.0 certification about three years ago, and there is one modelling problem that keeps coming back in our implementations. I would be very interested to hear how other experienced … --- ## [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… --- ## [Modeling Energy Loadprofiles in DV](https://forum.data-community.org/t/modeling-energy-loadprofiles-in-dv/2031)
**Author:** [@lorogno](https://forum.data-community.org/u/lorogno)\ **Replies:** 8\ **Last updated:** [February 4, 2026, 5:51pm UTC](https://forum.data-community.org/t/modeling-energy-loadprofiles-in-dv/2031 "2026-02-04T17:51:42Z")
Hey! I would be very grateful to have some feedbacks on a specific Modeling scenario in Energy Sector: We want to Model a Energy Meteringpoints with Loadprofiles in Data Vault. As central Business Entity there is the M… --- ## [Zero records causing issue in satellite](https://forum.data-community.org/t/zero-records-causing-issue-in-satellite/1939)
**Author:** [@Rupa](https://forum.data-community.org/u/Rupa)\ **Replies:** 8\ **Last updated:** [August 31, 2025, 8:41am UTC](https://forum.data-community.org/t/zero-records-causing-issue-in-satellite/1939 "2025-08-31T08:41:29Z")
Looking for some suggestions please how to deal with this situation we have come across in satellite(of hub). While loading source records for zero keys(i.e. null business key) in Satellite, we can see multiple records … --- ## [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… --- ## [Entity attributes with attributes](https://forum.data-community.org/t/entity-attributes-with-attributes/1929)
**Author:** [@AlPetMaggioli](https://forum.data-community.org/u/AlPetMaggioli)\ **Replies:** 2\ **Last updated:** [August 18, 2025, 6:35am UTC](https://forum.data-community.org/t/entity-attributes-with-attributes/1929 "2025-08-18T06:35:46Z")
Hello everyone, I am new to data engineering and data vault so I need help for the use case I have stumbled upon. Let’s say that I have a business entity A that has been modeled as a hub. To each record of the entity A… --- ## [Why are hubs, links and satellites separate tables?](https://forum.data-community.org/t/why-are-hubs-links-and-satellites-separate-tables/1746)
**Author:** [@Hook](https://forum.data-community.org/u/Hook)\ **Replies:** 30\ **Last updated:** [August 10, 2025, 10:54pm UTC](https://forum.data-community.org/t/why-are-hubs-links-and-satellites-separate-tables/1746 "2025-08-10T22:54:17Z")
Hi there, I have reached out to the DV community on many occasions trying to get an answer to this question. I get that hubs, links and satellites are meant to keep business key, relationships and contextual information… --- ## [What's the best approach for removing columns from a satellite?](https://forum.data-community.org/t/whats-the-best-approach-for-removing-columns-from-a-satellite/1788)
**Author:** [@Frankie](https://forum.data-community.org/u/Frankie)\ **Replies:** 17\ **Last updated:** [August 8, 2025, 11:34am UTC](https://forum.data-community.org/t/whats-the-best-approach-for-removing-columns-from-a-satellite/1788 "2025-08-08T11:34:58Z")
Hi All, We’ve done some plugging away at our DV tech debt recently and found that there’s a metadata column that we would like to remove from a satellite, It’s not breaking anything to keep around but it’s rapidly chang… --- ## [Tracking deletes on a link satellite with a dependent child key](https://forum.data-community.org/t/tracking-deletes-on-a-link-satellite-with-a-dependent-child-key/1910)
**Author:** [@mabrouk.gadri](https://forum.data-community.org/u/mabrouk.gadri)\ **Replies:** 3\ **Last updated:** [July 28, 2025, 4:57am UTC](https://forum.data-community.org/t/tracking-deletes-on-a-link-satellite-with-a-dependent-child-key/1910 "2025-07-28T04:57:41Z")
Is there a recommended approach to track deleted records on a link satellite with a dependent child key ? As an example, an investment is placed by a fund into another fund. The investment is represented by a link betw… --- ## [Conforming data from multiple systems...where does it happen?](https://forum.data-community.org/t/conforming-data-from-multiple-systems-where-does-it-happen/1870)
**Author:** [@mlord1979](https://forum.data-community.org/u/mlord1979)\ **Replies:** 6\ **Last updated:** [July 15, 2025, 2:27am UTC](https://forum.data-community.org/t/conforming-data-from-multiple-systems-where-does-it-happen/1870 "2025-07-15T02:27:16Z")
Hi, I have a scenario where we have some claims data from 2 source systems representing 2 different areas of the Business. Part of the requirement is to have one table with the claims from both systems. Whilst the 2 sour… --- ## [Different satellite load pattern for immutable data?](https://forum.data-community.org/t/different-satellite-load-pattern-for-immutable-data/1897)
**Author:** [@Frankie](https://forum.data-community.org/u/Frankie)\ **Replies:** 4\ **Last updated:** [July 11, 2025, 8:24am UTC](https://forum.data-community.org/t/different-satellite-load-pattern-for-immutable-data/1897 "2025-07-11T08:24:06Z")
Hi all, I was thinking today about entities that are largely immutable. We have a number of scenarios where once an entity is defined in our source it’s never changed. Those familiar with dimensional models will have ma… --- ## [Alternate id in another source system](https://forum.data-community.org/t/alternate-id-in-another-source-system/1863)
**Author:** [@tirdman](https://forum.data-community.org/u/tirdman)\ **Replies:** 3\ **Last updated:** [June 4, 2025, 3:31pm UTC](https://forum.data-community.org/t/alternate-id-in-another-source-system/1863 "2025-06-04T15:31:12Z")
Hello everyone! Perhaps the question has already been discussed, but unfortunately I couldn’t find it. There are 5 source systems. Sources are loaded independently of each other. In 4 of them the business key is pres… --- ## [Satelite on satelite approach](https://forum.data-community.org/t/satelite-on-satelite-approach/1854)
**Author:** [@CuriousMind](https://forum.data-community.org/u/CuriousMind)\ **Replies:** 4\ **Last updated:** [May 28, 2025, 7:36pm UTC](https://forum.data-community.org/t/satelite-on-satelite-approach/1854 "2025-05-28T19:36:55Z")
Dear All, In our data , we have two descriptive entities (satellites )depending on one main entity(hub) . One of these satellites is dependent on another. There are two ways to model this satellite in data vault - A… --- ## [Data Feed of Deltas: Candidate for Non-Historized Link?](https://forum.data-community.org/t/data-feed-of-deltas-candidate-for-non-historized-link/1843)
**Author:** [@MarkyMark](https://forum.data-community.org/u/MarkyMark)\ **Replies:** 3\ **Last updated:** [May 19, 2025, 1:47am UTC](https://forum.data-community.org/t/data-feed-of-deltas-candidate-for-non-historized-link/1843 "2025-05-19T01:47:57Z")
We are about to receive a data feed where the source data is being pushed to us once per day, and each day represents deltas. SourceFileName FILE\_NAME\_20250425210549.csv FILE\_NAME\_20250426210417.csv FILE\_NAM… --- ## [Multi Active Satelite or Normaization needed?](https://forum.data-community.org/t/multi-active-satelite-or-normaization-needed/1814)
**Author:** [@Dorry](https://forum.data-community.org/u/Dorry)\ **Replies:** 5\ **Last updated:** [April 13, 2025, 8:53am UTC](https://forum.data-community.org/t/multi-active-satelite-or-normaization-needed/1814 "2025-04-13T08:53:28Z")
Hi guys, first question here (i’m a data vault beginner :slight\_smile: ) Imagine having a source table with the following data |Client ID |Rating agentur (A/B) |Rating method (L/S) |Trustful (Y/N) |Raing data |Rating… --- ## [Satellite naming](https://forum.data-community.org/t/satellite-naming/1818)
**Author:** [@Rupa](https://forum.data-community.org/u/Rupa)\ **Replies:** 3\ **Last updated:** [April 11, 2025, 11:23am UTC](https://forum.data-community.org/t/satellite-naming/1818 "2025-04-11T11:23:49Z")
My Question is around naming of satellite: System A sends data to system B . System B passes the same data to EDW where we are doing RDV. System B is not doing any transformation of the data, it’s simply passing the da… --- ## [AutomateDV Initial Load](https://forum.data-community.org/t/automatedv-initial-load/1789)
**Author:** [@MarkyMark](https://forum.data-community.org/u/MarkyMark)\ **Replies:** 1\ **Last updated:** [March 27, 2025, 10:32pm UTC](https://forum.data-community.org/t/automatedv-initial-load/1789 "2025-03-27T22:32:46Z")
We have a reliable date received in one of our data feeds. To initially load the data, I assume it is fair game to use the date received as the load date time in Dbt Vault, and then change back to the run date. --- ## [Clarification on src\_eff: "EFFECTIVE\_FROM" in Staging Files](https://forum.data-community.org/t/clarification-on-src-eff-effective-from-in-staging-files/1776)
**Author:** [@MarkyMark](https://forum.data-community.org/u/MarkyMark)\ **Replies:** 3\ **Last updated:** [March 21, 2025, 9:30am UTC](https://forum.data-community.org/t/clarification-on-src-eff-effective-from-in-staging-files/1776 "2025-03-21T09:30:23Z")
Is the effective from the updated/modified date in a data source, assuming that it is reliable, or is it the created date, meaning that it will always be the same regardless of the load? If the record is updated, is it … --- ## [Modelling Counterparty / GUID / BK](https://forum.data-community.org/t/modelling-counterparty-guid-bk/1736)
**Author:** [@Chris](https://forum.data-community.org/u/Chris)\ **Replies:** 3\ **Last updated:** [February 14, 2025, 11:15pm UTC](https://forum.data-community.org/t/modelling-counterparty-guid-bk/1736 "2025-02-14T23:15:33Z")
Hi, Currently, I have the following source data regarding counterparties/companies: The source provides the columns GUID, NAME, and CUSTOMER\_ID, along with corresponding descriptive properties. The NAME column and the … --- ## [\[Need Advice\] Sat Table Reloading Stretegy](https://forum.data-community.org/t/need-advice-sat-table-reloading-stretegy/1729)
**Author:** [@Samvar](https://forum.data-community.org/u/Samvar)\ **Replies:** 1\ **Last updated:** [February 11, 2025, 10:00pm UTC](https://forum.data-community.org/t/need-advice-sat-table-reloading-stretegy/1729 "2025-02-11T22:00:13Z")
Hey there , I want some advice on the data vault modelling and load stretegy of the sat table. In our load progress we have load from the data lake into the landing layer in the batches and these landing layer are use… --- ## [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… --- ## [Multi-active Satellites](https://forum.data-community.org/t/multi-active-satellites/866)
**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")
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… --- ## [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… --- ## [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… --- ## [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… --- ## [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 … --- ## [Sat hash Diff Calculation](https://forum.data-community.org/t/sat-hash-diff-calculation/1243)
**Author:** [@kvs.naidu](https://forum.data-community.org/u/kvs.naidu)\ **Replies:** 1\ **Last updated:** [April 10, 2024, 9:56am UTC](https://forum.data-community.org/t/sat-hash-diff-calculation/1243 "2024-04-10T09:56:15Z")
Usually hash difference in satellite calculates on user columns. it is like md5(name+address+pincode+country). is it good to include foreign keys in hash diff calculation ? md5(name+address+pincode+country+region\_id(fk… --- ## [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… --- ## [Including additional keys as primary keys in satellite](https://forum.data-community.org/t/including-additional-keys-as-primary-keys-in-satellite/1207)
**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")
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… [Next page](https://forum.data-community.org/tag/satellite/49.md?match_all_tags=true&page=1&tags%5B%5D=satellite)