--- title: Multi-Active Satellite description: A Multi-Active Satellite stores several active rows per business key of a Hub, told apart by BG_Sequence, and their history in a Raw Vault table. --- [Skip to content](https://knowledge.bigenius-x.com/multi-active-satellite#main-content) [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new?hsLang=en) [Go to Customer Portal](https://knowledge.bigenius-x.com/customer-portal?hsLang=en) [![TRI\_Logo\_biGENIUS\_2020\_RGB\_s](https://knowledge.bigenius-x.com/hs-fs/hubfs/Marketing/TRI_Logo_biGENIUS_2020_RGB_s.png?width=150&height=42&name=TRI_Logo_biGENIUS_2020_RGB_s.png)](https://www.bigenius-x.com/) Open main navigation Close main navigation - [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new) - [Go to Customer Portal](https://knowledge.bigenius-x.com/customer-portal) How can we help you? - There are no suggestions because the search field is empty. 1. [biGENIUS-X Knowledge Base](https://knowledge.bigenius-x.com/?hsLang=en) 2. [Generators](https://knowledge.bigenius-x.com/generators?hsLang=en) 3. [Model Object Type](https://knowledge.bigenius-x.com/generators?hsLang=en#model-object-type) # Multi-Active Satellite **Applies to** Platform: Microsoft SQL Server · Snowflake · Snowflake dbt · Databricks · Databricks dbt · Fabric Lakehouse · Fabric Warehouse · Oracle Architecture: Data Vault A Multi-Active Satellite stores several active rows per business key of a Hub, told apart by `BG_Sequence`, and their history in a table of the Raw Vault layer. Use it when a key has a set of equal-ranking values at the same time, such as the phone numbers of an employee. After each load, the result view shows every version of each key's set with its validity. ### Sources and relationships A Multi-Active Satellite reads [Stages](https://knowledge.bigenius-x.com/stage?hsLang=en), [RawVault Composites](https://knowledge.bigenius-x.com/rawvault-composite?hsLang=en) and [Store Entities](https://knowledge.bigenius-x.com/store-entity?hsLang=en) of a linked Data Store project, in one or more dataflows. It has exactly one relationship to a [Hub](https://knowledge.bigenius-x.com/hub?hsLang=en), and its foreign-key terms must be mapped. [Vault Out](https://knowledge.bigenius-x.com/vault-out?hsLang=en) and the Business Vault types can read it; Current View, History View, PIT and BusinessVault Composite do not accept it as a source. ### Create a Multi-Active Satellite - With the wizard: open the menu of a Stage, RawVault Composite or Store Entity, choose **Automate** and then **Create Multi-Active Satellite**. Its steps are [Create Model Object](https://knowledge.bigenius-x.com/wizard-step-create-model-object?hsLang=en), [Create Dataflow](https://knowledge.bigenius-x.com/wizard-step-create-dataflow?hsLang=en), [Create Relations](https://knowledge.bigenius-x.com/wizard-step-create-relations?hsLang=en), [Map Foreign Key Terms](https://knowledge.bigenius-x.com/wizard-step-map-foreign-key-terms?hsLang=en), [Map Selected Terms](https://knowledge.bigenius-x.com/wizard-step-map-selected-terms?hsLang=en) and [Add to View](https://knowledge.bigenius-x.com/wizard-step-add-to-view?hsLang=en). See [Create a Model Object with the wizard](https://knowledge.bigenius-x.com/create-a-model-object-with-the-wizard?hsLang=en). - Manually: [create a model object](https://knowledge.bigenius-x.com/create-a-model-object?hsLang=en) of type Multi-Active Satellite in the Raw Vault layer, [add a relationship](https://knowledge.bigenius-x.com/add-a-relationship?hsLang=en) to the Hub, [create a dataflow set](https://knowledge.bigenius-x.com/create-a-data-flow-set?hsLang=en), [add the source model object](https://knowledge.bigenius-x.com/add-a-model-object-into-a-data-flow-set?hsLang=en) and [map the terms](https://knowledge.bigenius-x.com/map-a-source-term-with-a-target-term?hsLang=en). In both cases, map `BG_Sequence` to a source term that identifies the row within the set, for example a phone number ID or a `ROW_NUMBER()` expression. Validation reports an error when it is not mapped. ### Historization The loader compares the whole set of a key with the current set. When any row of the set is new, changed or missing, the loader inserts all rows that the source delivers for that key as a new version. The new set starts at the load timestamp and the previous set ends there, all its rows at once. An unchanged set adds no version, and the loader never deletes or updates rows. - The row hash `BG_RowHash` of each row covers the descriptive terms. `BG_Sequence`, foreign keys, Default Terms and the terms listed in [Excluded from Delta Detection](https://knowledge.bigenius-x.com/excluded-from-delta-detection-model-object?hsLang=en) are not part of it. - The internal term [`BG_MAS_HubDifferenceFound`](https://knowledge.bigenius-x.com/bg_mas_hubdifferencefound?hsLang=en) marks the keys whose set differs. - With [Persist Validity](https://knowledge.bigenius-x.com/persist-validity-project?hsLang=en) `false`, the result view calculates `BG_ValidToTimestamp` for the whole set; with `true`, the table stores it. ### Properties - [Implementation Type](https://knowledge.bigenius-x.com/implementation-type-model-object?hsLang=en): `Permanent` only. - [Foreign Key Mode](https://knowledge.bigenius-x.com/foreign-key-mode-model-object?hsLang=en): whether the table gets a foreign key to the Hub table. With `Create Disabled`, the default, it is created and disabled. - [Load Caching](https://knowledge.bigenius-x.com/load-caching-model-object?hsLang=en): empty (default) or `Hashing`, which stores the hashing view in a table before the loader runs. - [Increment Management Type](https://knowledge.bigenius-x.com/increment-management-type-model-object?hsLang=en): `Auto` (default) or `User`, for an incremental load with [`BG_IncrementalFilter`](https://knowledge.bigenius-x.com/bg_incrementalfilter?hsLang=en). See [Configure an incremental load](https://knowledge.bigenius-x.com/configure-an-incremental-load?hsLang=en). - [Custom Singleton Values](https://knowledge.bigenius-x.com/custom-singleton-values-model-object?hsLang=en): values of the unknown-member row. - [Excluded from Delta Detection](https://knowledge.bigenius-x.com/excluded-from-delta-detection-model-object?hsLang=en): terms that are stored but do not start a new version. - [Deduplication Method](https://knowledge.bigenius-x.com/deduplication-method-dataflow?hsLang=en) and [Sort Order within Partition](https://knowledge.bigenius-x.com/sort-order-within-partition-dataflow?hsLang=en), per dataflow. - [Use Embryo Loader](https://knowledge.bigenius-x.com/embryo-loader?hsLang=en), on the relationship: inserts Hub keys that the Hub does not hold yet. The project properties Persist Validity and [Create Result Views](https://knowledge.bigenius-x.com/create-result-views-project?hsLang=en) also apply. Version Valid From Term is not available. ### Default Terms - [`Hub_HK`](https://knowledge.bigenius-x.com/hub_hk?hsLang=en): the key of the Hub row, calculated from the foreign-key terms. - [`BG_Sequence`](https://knowledge.bigenius-x.com/bg_sequence?hsLang=en): identifies the row within the set. With `Hub_HK` and `BG_ValidFromTimestamp` it forms the primary key. - [`BG_ValidFromTimestamp`](https://knowledge.bigenius-x.com/bg_validfromtimestamp?hsLang=en) and [`BG_ValidToTimestamp`](https://knowledge.bigenius-x.com/bg_validtotimestamp?hsLang=en): start and end of the set's version. - [`BG_RowHash`](https://knowledge.bigenius-x.com/bg_rowhash?hsLang=en): hash of the descriptive terms of the row. - [`BG_IncrementalFilter`](https://knowledge.bigenius-x.com/bg_incrementalfilter?hsLang=en): source term for an incremental load; not stored in the table. - [`BG_LoadTimestamp`](https://knowledge.bigenius-x.com/bg_loadtimestamp?hsLang=en) and [`BG_SourceSystem`](https://knowledge.bigenius-x.com/bg_sourcesystem?hsLang=en): the load that inserted the row and its source system, empty unless you map it. - [`BG_MAS_HubDifferenceFound`](https://knowledge.bigenius-x.com/bg_mas_hubdifferencefound?hsLang=en): internal, hidden in source and target. - [`BG_DataQuality_ID`](https://knowledge.bigenius-x.com/bg-dataquality-id?hsLang=en), [`BG_ErrorCount`](https://knowledge.bigenius-x.com/bg_errorcount?hsLang=en) and [`BG_ErrorDescription`](https://knowledge.bigenius-x.com/bg_errordescription?hsLang=en): hidden terms of the data quality objects. ### Generated objects These are the names on Microsoft SQL Server for the Multi-Active Satellite `load_mas` with one dataflow: | Role | Generated name | Purpose | | --- | --- | --- | | Source | `RDV_MAS_load_mas_Source` | Reads the sources | | Deduplication | `RDV_MAS_load_mas_Deduplication` | Removes duplicate rows | | Hashing | `RDV_MAS_load_mas_Hashing` | Calculates the hash keys | | HashingStorage | `RDV_MAS_load_mas_HashingTable` | Stores the hashed rows | | HashingLoader | `RDV_MAS_load_mas_HashingLoader` | Fills the hashing table | | IncrementSource | `RDV_MAS_load_mas_IncrementSource` | Finds the new increment | | Increment | `RDV_MAS_load_mas_Increment` | Stores the increments | | EmbryoLoader | `RDV_MAS_load_mas_EmbryoLoader` | Adds missing Hub keys | | Delta | `RDV_MAS_load_mas_Delta` | Selects changed sets | | Loader | `RDV_MAS_load_mas_Loader` | Inserts the new sets | | Storage | `RDV_MAS_load_mas` | Multi-Active Satellite table | | Result | `RDV_MAS_load_mas_Result` | Query view with validity | - Loaders are stored procedures; the Multi-Active Satellite table, the hashing table and the increment table are tables; all other objects are views. - The deduplication view exists only with a Deduplication Method other than `None`. - The hashing table and hashing loader exist only with Load Caching `Hashing`. - The increment table exists only with an incremental load, that is, when a dataflow maps `BG_IncrementalFilter`; the increment source view only with Increment Management Type `Auto`. - The embryo loader exists only when Use Embryo Loader is true on the relationship. It runs before the loader. - The result view exists only with Create Result Views; without it, Persist Validity must be true. - With several dataflows, all objects except the table and the result view exist once per dataflow, with the dataflow name in their names. - The table script inserts the unknown-member row with a `Hub_HK` of zeros and `BG_Sequence` 0. The result view hides it. - There are no versioning or row-condensing views. With the default settings, a load runs this chain: ``` sources -> _Source -> _Hashing -> _Delta -> _Loader _Loader -> RDV_MAS_load_mas -> _Result _Result -> _Delta (current sets) ``` The delta view joins the source rows with the current set of each key by `BG_Sequence`. When any row hash differs or a sequence exists on one side only, it marks the key and keeps all source rows of that key. The loader inserts them with the load timestamp as `BG_ValidFromTimestamp`. With the optional objects, `_Deduplication` sits before `_Hashing`, `_HashingTable` after it, and `_Increment` filters `_Source`. ### Example The Multi-Active Satellite `load_mas` on Microsoft SQL Server reads the Stage `PHONENUMBER`, filtered on employee phone numbers. It has a relationship to the Hub `common_employee`, and `BG_Sequence` is mapped to `PHONENUMBER_ID`. Persist Validity is false. The loads deliver these numbers: - Load 1 on 2026-10-28 08:00: employee 101 has the mobile number 1 (+41 79 111 11 11) and the office number 2 (+41 44 222 22 22); employee 102 has the mobile number 3 (+49 151 333 33 33). - Load 2 on 2026-10-29 08:00: the office number 2 of employee 101 changes to +41 44 222 22 99. - Load 3 on 2026-10-30 08:00: number 2 of employee 101 is no longer delivered. ### Check the result Query the result view with the business key from the Hub, here in the schema `rv`: ``` SELECT h.EMPLOYEE_ID, m.BG_Sequence, m.PHONE_NUMBER, m.BG_ValidFromTimestamp, m.BG_ValidToTimestamp FROM rv.RDV_MAS_load_mas_Result AS m JOIN rv.RDV_HUB_common_employee_Result AS h ON h.Hub_HK = m.Hub_HK ORDER BY h.EMPLOYEE_ID, m.BG_ValidFromTimestamp, m.BG_Sequence; ``` This is the result after load 3, split into two blocks with the column names shortened: ``` EMPLOYEE_ID SEQ PHONE_NUMBER ValidFrom 101 1 +41 79 111 11 11 2026-10-28 08:00 101 2 +41 44 222 22 22 2026-10-28 08:00 101 1 +41 79 111 11 11 2026-10-29 08:00 101 2 +41 44 222 22 99 2026-10-29 08:00 101 1 +41 79 111 11 11 2026-10-30 08:00 102 3 +49 151 333 33 33 2026-10-28 08:00 ``` ``` EMPLOYEE_ID SEQ ValidFrom ValidTo 101 1 2026-10-28 08:00 2026-10-29 08:00 101 2 2026-10-28 08:00 2026-10-29 08:00 101 1 2026-10-29 08:00 2026-10-30 08:00 101 2 2026-10-29 08:00 2026-10-30 08:00 101 1 2026-10-30 08:00 9999-12-31 00:00 102 3 2026-10-28 08:00 9999-12-31 00:00 ``` - Load 2 changed one number of employee 101 and inserted the whole set again, also the unchanged mobile number 1. - Load 3 dropped number 2; the new set holds only number 1, and the set of load 2 ended at load 3. - Employee 102 kept the set of load 1. ### Platform differences - Persist Validity is true by default on Snowflake, Snowflake dbt, Databricks, Databricks dbt, Fabric Lakehouse and Fabric Warehouse, and false on Microsoft SQL Server and Oracle. - Snowflake: names are in capitals, and the loader is a stored procedure. The load control task `LC_RDV_MAS__TASK` calls it. The dataflow properties [Use Stream](https://knowledge.bigenius-x.com/use-stream-model-object?hsLang=en) and [Warehouse Placeholder Variable Name](https://knowledge.bigenius-x.com/warehouse-placeholder-variable-name-dataflow?hsLang=en) apply. - Databricks and Fabric Lakehouse: table and view names are in lowercase, and the loader is the notebook `RDV_MAS__Loader`. The properties [File Format](https://knowledge.bigenius-x.com/file-format-model-object?hsLang=en), [Optimization Method](https://knowledge.bigenius-x.com/optimization-method-model-object?hsLang=en), [Optimization Method Columns](https://knowledge.bigenius-x.com/optimization-method-columns-model-object?hsLang=en) and [Use Sequential Dataflow Execution](https://knowledge.bigenius-x.com/use-sequential-dataflow-execution-model-object?hsLang=en) apply. Fabric Lakehouse allows only Foreign Key Mode `None`. - Databricks dbt and Snowflake dbt: the Multi-Active Satellite becomes the dbt models `rdv_mas__source` and `rdv_mas_`. The model `rdv_mas__result` exists only when Create Result Views is true; the default on dbt is false. Load Caching, Increment Management Type and Use Embryo Loader are not available. - Fabric Warehouse: the same objects as on Microsoft SQL Server, deployed by notebooks. - Oracle: names are in capitals, and the loader is a PL/SQL package. [Hash Group Size](https://knowledge.bigenius-x.com/hash-group-size-model-object?hsLang=en) splits the input of `BG_RowHash` into groups of terms that are hashed separately. [Partition Clause](https://knowledge.bigenius-x.com/partition-clause-and-table-storage-model-object?hsLang=en) adds its text to the `CREATE TABLE` statement. Table Compression, the tablespaces and the statistics properties also apply. - Foreign Key Mode `Create Enforced` exists only on Microsoft SQL Server and Oracle. ### Limitations - A Multi-Active Satellite has exactly one relationship to a Hub, and `BG_Sequence` must be mapped. Business keys raise a validation warning. - Multi-version loading is not available. ### Release differences - Generator 2.2: Increment Management Type, Use Embryo Loader and Persist Validity are available. - Generator 2.3: Custom Singleton Values is available, and Hash Group Size on Oracle. - Generator 2.4: a new, changed or missing sequence replaces the whole set of the key, and the previous set ends as a whole. Excluded from Delta Detection is available. ### Related articles - Previous: [Hub](https://knowledge.bigenius-x.com/hub?hsLang=en) - Reference: [BG\_Sequence](https://knowledge.bigenius-x.com/bg_sequence?hsLang=en), [BG\_MAS\_HubDifferenceFound](https://knowledge.bigenius-x.com/bg_mas_hubdifferencefound?hsLang=en), [BG\_RowHash](https://knowledge.bigenius-x.com/bg_rowhash?hsLang=en), [Excluded from Delta Detection (Model Object)](https://knowledge.bigenius-x.com/excluded-from-delta-detection-model-object?hsLang=en), [Persist Validity (Project)](https://knowledge.bigenius-x.com/persist-validity-project?hsLang=en), [Create Result Views (Project)](https://knowledge.bigenius-x.com/create-result-views-project?hsLang=en), [Custom Singleton Values (Model Object)](https://knowledge.bigenius-x.com/custom-singleton-values-model-object?hsLang=en), [Hash Group Size (Model Object)](https://knowledge.bigenius-x.com/hash-group-size-model-object?hsLang=en), [Foreign Key Mode (Model Object)](https://knowledge.bigenius-x.com/foreign-key-mode-model-object?hsLang=en) - See also: [Satellite](https://knowledge.bigenius-x.com/satellite?hsLang=en), [Change detection and historization](https://knowledge.bigenius-x.com/change-detection-and-historization?hsLang=en), [Embryo Loader](https://knowledge.bigenius-x.com/embryo-loader?hsLang=en), [Create a Model Object with the wizard](https://knowledge.bigenius-x.com/create-a-model-object-with-the-wizard?hsLang=en) - [Getting started](https://knowledge.bigenius-x.com/getting-started?hsLang=en#main-content) - [Guidelines](https://knowledge.bigenius-x.com/getting-started?hsLang=en#guidelines) - [Start working](https://knowledge.bigenius-x.com/getting-started?hsLang=en#start-working) - [Account](https://knowledge.bigenius-x.com/getting-started?hsLang=en#account) - [General overview](https://knowledge.bigenius-x.com/general-overview?hsLang=en) - [Artificial Intelligence](https://knowledge.bigenius-x.com/artificial-intelligence?hsLang=en) - [Application Modules](https://knowledge.bigenius-x.com/application-modules?hsLang=en#main-content) - [Administration](https://knowledge.bigenius-x.com/application-modules?hsLang=en#administration) - [Solutions](https://knowledge.bigenius-x.com/application-modules?hsLang=en#solutions) - [Global Features](https://knowledge.bigenius-x.com/application-modules?hsLang=en#global-features) - [Projects](https://knowledge.bigenius-x.com/application-modules?hsLang=en#projects) - [Branches](https://knowledge.bigenius-x.com/application-modules?hsLang=en#branches) - [Data Connections](https://knowledge.bigenius-x.com/application-modules?hsLang=en#data-connections) - [Dataflow Modeling - Overview](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-overview) - [Dataflow Modeling - Wizard Steps](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-wizard-steps) - [Dataflow Modeling - Terms](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-terms) - [Dataflow Modeling - Term Mapping](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-term-mapping) - [Dataflow Modeling - Relationships](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-relationships) - [Dataflow Modeling - Data Quality](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-data-quality) - [Dataflow Modeling - Indexes](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-indexes) - [Relationship Modeling](https://knowledge.bigenius-x.com/application-modules?hsLang=en#relationship-modeling) - [Generate Artifacts](https://knowledge.bigenius-x.com/application-modules?hsLang=en#generate-artifacts) - [Project Settings](https://knowledge.bigenius-x.com/application-modules?hsLang=en#project-settings) - [Data Marketplace](https://knowledge.bigenius-x.com/application-modules?hsLang=en#data-marketplace) - [Generators](https://knowledge.bigenius-x.com/generators?hsLang=en#main-content) - [Fabric Warehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-warehouse) - [Fabric Lakehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-lakehouse) - [Databricks](https://knowledge.bigenius-x.com/generators?hsLang=en#databricks) - [Snowflake](https://knowledge.bigenius-x.com/generators?hsLang=en#snowflake) - [Microsoft SQL Server](https://knowledge.bigenius-x.com/generators?hsLang=en#microsoft-sql-server) - [Oracle](https://knowledge.bigenius-x.com/generators?hsLang=en#oracle) - [Artifacts](https://knowledge.bigenius-x.com/generators?hsLang=en#artifacts) - [Replace Placeholders](https://knowledge.bigenius-x.com/generators?hsLang=en#replace-placeholders) - [Target solution environment](https://knowledge.bigenius-x.com/generators?hsLang=en#target-solution-environment) - [Deployment](https://knowledge.bigenius-x.com/generators?hsLang=en#deployment) - [Deployment with an Azuze DevOps pipeline](https://knowledge.bigenius-x.com/generators?hsLang=en#deployment-with-an-azuze-devops-pipeline) - [Delta Deployment](https://knowledge.bigenius-x.com/generators?hsLang=en#delta-deployment) - [Load control environment](https://knowledge.bigenius-x.com/generators?hsLang=en#load-control-environment) - [Load data with a native load control](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-a-native-load-control) - [Load data with Apache Airflow](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-apache-airflow) - [Model Object Type](https://knowledge.bigenius-x.com/generators?hsLang=en#model-object-type) - [Properties](https://knowledge.bigenius-x.com/generators?hsLang=en#properties) - [Default Terms](https://knowledge.bigenius-x.com/generators?hsLang=en#default-terms) - [Discovery application](https://knowledge.bigenius-x.com/discovery-application?hsLang=en#main-content) - [Discovery configurations](https://knowledge.bigenius-x.com/discovery-application?hsLang=en#discovery-configurations) - [Best practices](https://knowledge.bigenius-x.com/best-practices?hsLang=en#main-content) - [Modeling Approaches](https://knowledge.bigenius-x.com/best-practices?hsLang=en#modeling-approaches) - [Use Cases](https://knowledge.bigenius-x.com/best-practices?hsLang=en#use-cases) - [Business Rules](https://knowledge.bigenius-x.com/best-practices?hsLang=en#business-rules) - [Data Quality Rules](https://knowledge.bigenius-x.com/best-practices?hsLang=en#data-quality-rules) - [FAQs](https://knowledge.bigenius-x.com/faqs?hsLang=en) - [Product Release Notes](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#main-content) - [SaaS Application](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#saas-application) - [Discovery application](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#discovery-application) - [Generators](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#generators) - [Legal Documents](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#main-content) - [Current legal docs](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#current-legal-docs) - [Software Product and Limits](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#software-product-and-limits) - [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new?hsLang=en) - [Customer Portal](https://knowledge.bigenius-x.com/customer-portal) - [Sign in](https://knowledge.bigenius-x.com/_hcms/mem/login) [![biGENIUS logo](https://knowledge.bigenius-x.com/hubfs/TRI_Logo_biGENIUS_2020_RGB-1.svg "biGENIUS logo")](https://www.bigenius-x.com) All rights reserved © 2025, biGENIUS AG