--- title: Record Tracking Link Satellite description: A Record Tracking Link Satellite records in which loads the rows of a Link appeared in the source, in a table of the Raw Vault layer. --- [Skip to content](https://knowledge.bigenius-x.com/record-tracking-link-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) # Record Tracking Link Satellite **Applies to** Platform: Microsoft SQL Server · Snowflake · Snowflake dbt · Databricks · Databricks dbt · Fabric Lakehouse · Fabric Warehouse · Oracle Architecture: Data Vault A Record Tracking Link Satellite records in which loads the rows of a Link appeared in the source, in a table of the Raw Vault layer. Use it to see when a relationship between business keys was delivered and, with Delete Detection Method `FullSet`, in which loads it was missing. After each load, the result view shows one row per Link row and load with its `BG_Appearance` value. ### Sources and relationships A Record Tracking Link 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 [Link](https://knowledge.bigenius-x.com/link?hsLang=en), [Hierarchical Link](https://knowledge.bigenius-x.com/hierarchical-link?hsLang=en), [Same As Link](https://knowledge.bigenius-x.com/same-as-link?hsLang=en) or [Driving Key Link](https://knowledge.bigenius-x.com/driving-key-link?hsLang=en). Its foreign-key terms are the business keys of the Link's Hubs, and they must be mapped. BusinessVault Composite, [Vault Out](https://knowledge.bigenius-x.com/vault-out?hsLang=en) and the Business Vault types can read it. PIT, Current View and History View do not read it. ### Create the model object - With the wizard: open the menu of a Stage, RawVault Composite or Store Entity, choose **Automate** and then **Create Record Tracking Link 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) 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 Record Tracking Link Satellite in the Raw Vault layer, [add a relationship](https://knowledge.bigenius-x.com/add-a-relationship?hsLang=en) to the Link, [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 foreign-key terms](https://knowledge.bigenius-x.com/map-a-source-term-with-a-target-term?hsLang=en). You do not map `BG_Appearance`. The source view sets it to 1 for every Link row that the source delivers. ### Loading behavior Every load inserts one row for each Link row that the source delivers, with the load timestamp as `BG_ValidFromTimestamp` and `BG_Appearance` 1. A row is valid until the next row of the same `Link_HK`. Delete Detection Method decides what happens to a Link row that the source does not deliver: - `FullSet` (default): the delta view compares the source rows with the rows of the latest load in the table, by `Link_HK`. A Link row of that load that is missing from the source gets a row with `BG_Appearance` 0. It gets such a row in every load until the source delivers it again. - `None`: there is no delta view. The loader inserts the delivered Link rows only, so a missing Link row gets no row. With Delete Detection Method `FullSet`, every load must deliver all Link rows of the source. A Link row missing from one load gets a row with `BG_Appearance` 0. Load partial or per-day extracts with Delete Detection Method `None`. ### Properties - [Delete Detection Method](https://knowledge.bigenius-x.com/delete-detection-method-model-object?hsLang=en): `FullSet` (default) or `None`, see Loading behavior. - [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 Link 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. - [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 the Link keys that the Link does not hold yet. The project properties [Persist Validity](https://knowledge.bigenius-x.com/persist-validity-project?hsLang=en) and [Create Result Views](https://knowledge.bigenius-x.com/create-result-views-project?hsLang=en) also apply. ### Default Terms - [`Link_HK`](https://knowledge.bigenius-x.com/link_hk?hsLang=en): the key of the Link row, calculated from the foreign-key terms. With `BG_ValidFromTimestamp` it forms the primary key. - [`DrivingKeyLink_HK`](https://knowledge.bigenius-x.com/drivingkeylink_hk?hsLang=en): only on a Driving Key Link, the key of the driving relationships. - [`BG_Appearance`](https://knowledge.bigenius-x.com/bg_appearance?hsLang=en): 1 when the load delivered the Link row, 0 when it was missing. - [`BG_ValidFromTimestamp`](https://knowledge.bigenius-x.com/bg_validfromtimestamp?hsLang=en): the load timestamp of the row. - [`BG_ValidToTimestamp`](https://knowledge.bigenius-x.com/bg_validtotimestamp?hsLang=en): the start of the next row of the same Link row. - [`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_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. A Record Tracking Link Satellite has no `BG_RowHash` and no `BG_IncrementalFilter`. ### Generated objects These are the names on Microsoft SQL Server for a Record Tracking Link Satellite with one dataflow. `` stands for the name of the model object: | Role | Generated name | Purpose | | --- | --- | --- | | Source | `RDV_RLSAT__Source` | Reads the sources | | Deduplication | `RDV_RLSAT__Deduplication` | Removes duplicate rows | | Hashing | `RDV_RLSAT__Hashing` | Calculates `Link_HK` | | HashingStorage | `RDV_RLSAT__HashingTable` | Stores the hashed rows | | HashingLoader | `RDV_RLSAT__HashingLoader` | Fills the hashing table | | EmbryoLoader | `RDV_RLSAT__EmbryoLoader` | Adds missing Link keys | | Delta | `RDV_RLSAT__Delta` | Adds rows for missing Link rows | | Loader | `RDV_RLSAT__Loader` | Inserts the rows | | Storage | `RDV_RLSAT_` | Record Tracking Link Satellite table | | Result | `RDV_RLSAT__Result` | Query view with validity | - Loaders are stored procedures; the Record Tracking Link Satellite table and the hashing table are tables; all other objects are views. - The delta view exists only with Delete Detection Method `FullSet`. - 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 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 has no unknown-member row. With the default settings, a load runs this chain: ``` sources -> _Source -> _Hashing -> _Delta -> _Loader _Loader -> RDV_RLSAT_ -> _Result _Result -> _Delta (rows of the latest load) ``` The delta view joins the hashed source rows with the rows of the latest load in the result view, by `Link_HK`. Delivered Link rows keep `BG_Appearance` 1, and Link rows found only in the result view get 0. The loader inserts all rows of the delta view with the load timestamp. With `None`, the loader reads `_Hashing` directly. `_Deduplication` sits between `_Source` and `_Hashing`, and `_HashingTable` after `_Hashing`. ### Example The Record Tracking Link Satellite `record_tracking_with_delete_detection_lsat` on Microsoft SQL Server reads the Stage `CUSTOMER`. It has a relationship to the Link `single_customer_hub_lnk`, whose only relationship is to the customer Hub. Its Delete Detection Method is `FullSet`, and Persist Validity is false. The loads deliver these customers: - Load 1 on 2026-10-28 08:00: customers 1 and 2. - Load 2 on 2026-10-29 08:00: customers 1, 2 and 3. - Load 3 on 2026-10-30 08:00: customers 1 and 3. Customer 2 is missing. - Load 4 on 2026-10-31 08:00: customers 1, 2 and 3. ### Check the result Query the result view with the foreign key of the Link, here in the schema `p2`: ``` SELECT l.FK_load_customer_hub_CUSTOMER_CUSTOMER_ID AS CUSTOMER_ID, s.BG_Appearance, s.BG_ValidFromTimestamp, s.BG_ValidToTimestamp FROM p2.RDV_RLSAT_record_tracking_with_delete_detection_lsat_Result AS s JOIN p2.RDV_LNK_single_customer_hub_lnk_Result AS l ON l.Link_HK = s.Link_HK WHERE l.FK_load_customer_hub_CUSTOMER_CUSTOMER_ID = 2 ORDER BY s.BG_ValidFromTimestamp; ``` This is the result after load 4, with the column names and timestamps shortened: ``` CUSTOMER_ID BG_Appearance ValidFrom ValidTo 2 1 2026-10-28 08:00 2026-10-29 08:00 2 1 2026-10-29 08:00 2026-10-30 08:00 2 0 2026-10-30 08:00 2026-10-31 08:00 2 1 2026-10-31 08:00 9999-12-31 00:00 ``` - Load 3 did not deliver the Link row of customer 2 and inserted a row with `BG_Appearance` 0. Load 4 delivered it again and inserted a row with 1. - Every load inserted a row for each delivered Link row, also when nothing changed. ### 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. With true, the table stores `BG_ValidToTimestamp`. - The data type of `BG_Appearance` differs per platform, see [BG\_Appearance](https://knowledge.bigenius-x.com/bg_appearance?hsLang=en). - Snowflake: names are in capitals, and the loader is a stored procedure. A load control 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_RLSAT__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 Record Tracking Link Satellite becomes the dbt models `rdv_rlsat__source` and `rdv_rlsat_`. The model `rdv_rlsat__result` exists only when Create Result Views is true; the default on dbt is false. Load Caching 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. [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 Record Tracking Link Satellite has exactly one relationship, to a Link, Hierarchical Link, Same As Link or Driving Key Link. - A term other than the Default Terms, business keys and foreign keys raises a validation error. Business keys raise a validation warning. - Custom Singleton Values and Version Valid From Term are not available. ### Release differences - Generator 2.0: Delete Detection Method is available. - Generator 2.2: Use Embryo Loader and Persist Validity are available. ### Related articles - Previous: [Link](https://knowledge.bigenius-x.com/link?hsLang=en), [Driving Key Link](https://knowledge.bigenius-x.com/driving-key-link?hsLang=en), [Hierarchical Link](https://knowledge.bigenius-x.com/hierarchical-link?hsLang=en), [Same As Link](https://knowledge.bigenius-x.com/same-as-link?hsLang=en) - Reference: [BG\_Appearance](https://knowledge.bigenius-x.com/bg_appearance?hsLang=en), [Link\_HK](https://knowledge.bigenius-x.com/link_hk?hsLang=en), [DrivingKeyLink\_HK](https://knowledge.bigenius-x.com/drivingkeylink_hk?hsLang=en), [Delete Detection Method (Model Object)](https://knowledge.bigenius-x.com/delete-detection-method-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), [Foreign Key Mode (Model Object)](https://knowledge.bigenius-x.com/foreign-key-mode-model-object?hsLang=en), [Load Caching (Model Object)](https://knowledge.bigenius-x.com/load-caching-model-object?hsLang=en) - See also: [Record Tracking Satellite](https://knowledge.bigenius-x.com/record-tracking-satellite?hsLang=en), [Link Satellite](https://knowledge.bigenius-x.com/link-satellite?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