--- title: Store Entity description: A Store Entity stores the data of Stages or Store Composites per business key in a table of the Store layer and keeps the history of its SCD2 terms. --- [Skip to content](https://knowledge.bigenius-x.com/create-a-store-entity#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) # Store Entity **Applies to** Platform: Microsoft SQL Server · Snowflake · Databricks · Fabric Lakehouse · Fabric Warehouse · Oracle Architecture: Data Store A Store Entity stores the data of Stages or Store Composites per business key in a table of the Store layer and keeps the history of its SCD2 terms. Use it as the persistent layer of a Data Store, which Data Vault, Dimensional and Data Mart projects can read as a linked object. After each load, the result view shows one row per business key and version, with its validity. ### Sources and relationships A Store Entity reads [Stages](https://knowledge.bigenius-x.com/create-a-stage?hsLang=en) and [Store Composites](https://knowledge.bigenius-x.com/create-a-store-composite?hsLang=en), in one or more dataflows. It has no relationships. Other projects read it as a linked object: - Data Vault: Hub, Link, Same As Link, Hierarchical Link, Driving Key Link, all Raw Vault satellite types, RawVault Composite and Reference Table. - Dimensional: Entity, Fact and Core Composite. - Data Mart: Mart Dimension, Mart Fact and Mart Composite. ### Create a Store Entity - With the wizard: open the menu of a Stage or Store Composite, choose **Automate** and then **Create Store Entity**. 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), [Map Selected Business Keys](https://knowledge.bigenius-x.com/wizard-step-map-selected-business-keys?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). The wizard gives the mapped terms the Historization Type SCD2. See [Create a Model Object with the wizard](https://knowledge.bigenius-x.com/create-a-model-object-with-the-wizard?hsLang=en). ![Menu of a Stage with Automate and its entries Create Store Composite and Create Store Entity](https://knowledge.bigenius-x.com/hs-fs/hubfs/knowledge_base_screenshots/create-a-store-entity-automate-menu.png?width=403&height=250&name=create-a-store-entity-automate-menu.png) - Manually: [create a model object](https://knowledge.bigenius-x.com/create-a-model-object?hsLang=en) of type Store Entity in the Data Store column, [create a dataflow set](https://knowledge.bigenius-x.com/create-a-data-flow-set?hsLang=en), [add the source model objects](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). After manual creation, mark at least one term as business key. In both cases, set the [Historization Type](https://knowledge.bigenius-x.com/historization-type-term-and-relationship?hsLang=en) of the terms that are not SCD2. ### Historization - SCD2 (default): a changed value starts a new version at the load timestamp. - SCD1: a new value overwrites the term in every version of the business key. - SCD0: the value of the first load is kept. The first version of a business key starts at [Begin of Universe](https://knowledge.bigenius-x.com/begin-of-universe-project?hsLang=en), 1900-01-01 by default. A version ends where the next one starts; the current version ends at [End of Universe](https://knowledge.bigenius-x.com/end-of-universe-project?hsLang=en). Without SCD2 terms and without a Version Valid From Term, the table holds one row per business key and has no validity terms. When the terms mix Historization Types, validation reports the warning `uses mixed historization types`, and the load works, as in the example below. See [Change detection and historization](https://knowledge.bigenius-x.com/change-detection-and-historization?hsLang=en). ### Properties - [Implementation Type](https://knowledge.bigenius-x.com/implementation-type-model-object?hsLang=en): `Permanent` only, a table that keeps its rows from load to load. - [Delta Detection](https://knowledge.bigenius-x.com/delta-detection-model-object?hsLang=en): `Hash Value Comparison` (default) compares row hashes. `Column Comparison` compares the SCD1 and SCD2 terms column by column. - [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. - [Version Valid From Term](https://knowledge.bigenius-x.com/validfrom-source-term-dataflow-model-object?hsLang=en): per dataflow model object, for a source that delivers its own history. See [Configure a multi-version load](https://knowledge.bigenius-x.com/configure-a-multi-version-load?hsLang=en). - [Delete Detection Method](https://knowledge.bigenius-x.com/delete-detection-method?hsLang=en), [Delete Detection Source](https://knowledge.bigenius-x.com/delete-detection-source-model-object?hsLang=en), [Delete Detection Partial Terms](https://knowledge.bigenius-x.com/delete-detection-partial-terms?hsLang=en) and [Delete Detection Partial Operator](https://knowledge.bigenius-x.com/delete-detection-partial-operator?hsLang=en): see [Configure delete detection](https://knowledge.bigenius-x.com/configure-a-delete-detection-behavior?hsLang=en). - [Deduplication Method](https://knowledge.bigenius-x.com/deduplication-method-model-object?hsLang=en) and [Sort Order within Partition](https://knowledge.bigenius-x.com/deduplication-partition-model-object?hsLang=en), per dataflow. The project property [Persist Validity](https://knowledge.bigenius-x.com/persist-validity-project?hsLang=en) decides whether `BG_ValidToTimestamp` is a table column or calculated by the result view. ### Default Terms - [`BG_LoadTimestamp`](https://knowledge.bigenius-x.com/bg_loadtimestamp?hsLang=en): the load that inserted the row. - [`BG_UpdateTimestamp`](https://knowledge.bigenius-x.com/bg_updatetimestamp?hsLang=en): the load that last changed the row. - [`BG_SourceSystem`](https://knowledge.bigenius-x.com/bg_sourcesystem?hsLang=en): the source system of the row; empty unless you map it. - [`BG_ValidFromTimestamp`](https://knowledge.bigenius-x.com/bg_validfromtimestamp?hsLang=en) and [`BG_ValidToTimestamp`](https://knowledge.bigenius-x.com/bg_validtotimestamp?hsLang=en): only with SCD2 terms or a Version Valid From Term. With validity terms, the primary key is the business keys plus `BG_ValidFromTimestamp`; without them, it is the business keys alone. - [`BG_RowHashScd1`](https://knowledge.bigenius-x.com/bg_rowhashscd1?hsLang=en) and [`BG_RowHashScd2`](https://knowledge.bigenius-x.com/bg_rowhashscd2?hsLang=en): hashes of the SCD1 and of the SCD2 terms, each only when such terms exist. Business keys, Default Terms and SCD0 terms are not hashed. `Column Comparison` creates no row hashes. See [How biGENIUS-X builds hash values](https://knowledge.bigenius-x.com/how-bigenius-x-builds-hash-values?hsLang=en). - [`BG_IsDeleted`](https://knowledge.bigenius-x.com/bg_isdeleted?hsLang=en): only with delete detection. - [`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 a Store Entity `customer` with one dataflow: | Role | Generated name | Purpose | | --- | --- | --- | | Source | `DS_SE_customer_Source` | Joins the sources | | Deduplication | `DS_SE_customer_Deduplication` | Removes duplicate rows | | MultiVersion | `DS_SE_customer_Versioning` | Combines the source versions | | Scd | `DS_SE_customer_Scd` | Applies SCD0 and SCD1 across versions | | Hashing | `DS_SE_customer_Hashing` | Calculates the row hashes | | HashingStorage | `DS_SE_customer_HashingTable` | Stores the row hashes | | HashingLoader | `DS_SE_customer_HashingLoader` | Fills the hashing table | | RowCondensing | `DS_SE_customer_RowCondensing` | Merges equal versions | | Delta | `DS_SE_customer_Delta` | Selects new and changed rows | | Loader | `DS_SE_customer_Loader` | Loads the table | | Storage | `DS_SE_customer` | Store Entity table | | Result | `DS_SE_customer_Result` | Query view with validity | - Loaders are stored procedures; `DS_SE_customer` and the hashing table are tables; all other objects are views. - The deduplication view exists only with a Deduplication Method other than `None`. - Versioning, Scd and RowCondensing views exist only with a Version Valid From Term. - The hashing view exists only with `Hash Value Comparison` and at least one SCD1 or SCD2 term. The hashing table and hashing loader exist only with Load Caching `Hashing`. - Delete detection adds the view `_DeleteDetection`, the table `_DeleteDetectionTable` and the procedure `_DeleteDetectionLoader`. - A data quality rule that runs before the load adds `_DataQualityBeforeLoadAction`, `_DataQualityResult`, `_DataQualityTable` and `_DataQualityLoader`. Rule logging adds `_DataQualityError`. - With several dataflows, all objects except the table and the result view exist once per dataflow. Their names carry the dataflow name, for example `DS_SE_customer_Dataflow1_Loader`. With the default settings, the dependencies are: ``` sources -> _Source -> _Hashing -> _Delta -> _Loader _Loader -> DS_SE_customer -> _Result _Result -> _Delta (comparison with the stored rows) ``` ### Example The Store Entity `customer` on Microsoft SQL Server reads the Stage `customer`. `CUSTOMER_ID` is the business key. The example uses these terms: - `ADDRESS_LINE1`: SCD2. - `CUSTOMER`: SCD1. - `CUSTOMER_TYPE`: SCD0. Load 1 on 2026-10-28 delivers two customers: ``` CUSTOMER_ID CUSTOMER CUSTOMER_TYPE ADDRESS_LINE1 1 Contoso Ltd Business Main Street 1 2 Fabrikam AG Business Station Road 5 ``` Load 2 on 2026-10-29 changes customer 1 and adds customer 3: ``` CUSTOMER_ID CUSTOMER CUSTOMER_TYPE ADDRESS_LINE1 1 Contoso Group Enterprise Main Street 3 2 Fabrikam AG Business Station Road 5 3 Northwind Private Lake Road 7 ``` ### Check the result Query the result view, here in the schema `ds`: ``` SELECT CUSTOMER_ID, CUSTOMER, CUSTOMER_TYPE, ADDRESS_LINE1, BG_ValidFromTimestamp, BG_ValidToTimestamp, BG_LoadTimestamp, BG_UpdateTimestamp FROM ds.DS_SE_customer_Result ORDER BY CUSTOMER_ID, BG_ValidFromTimestamp; ``` This is the result after load 2, split into two blocks, with shortened column names and timestamps: ``` ID CUSTOMER CUSTOMER_TYPE ADDRESS_LINE1 1 Contoso Group Business Main Street 1 1 Contoso Group Business Main Street 3 2 Fabrikam AG Business Station Road 5 3 Northwind Private Lake Road 7 ``` ``` ID ValidFrom ValidTo LoadTs UpdateTs 1 1900-01-01 2026-10-29 2026-10-28 2026-10-29 1 2026-10-29 9999-12-31 2026-10-29 2026-10-29 2 1900-01-01 9999-12-31 2026-10-28 2026-10-28 3 1900-01-01 9999-12-31 2026-10-29 2026-10-29 ``` - The new address starts a second version of customer 1 at the load timestamp of load 2. - Contoso Group replaces Contoso Ltd in both versions, so the first version gets the update timestamp of load 2. - `CUSTOMER_TYPE` stays Business, because SCD0 keeps the first value. - Customer 3 is new, so its first version starts at 1900-01-01. - Repeating load 2 inserts and updates no row. ### Platform differences - Persist Validity is on by default on Snowflake, Databricks, Fabric Lakehouse and Fabric Warehouse, and off on Microsoft SQL Server and Oracle. - Snowflake: names are in capitals. The load control task `DS_SE__TASK` calls the loader; delete detection and data quality add their own tasks. 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: the loader is the notebook `DS_SE__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 Warehouse: the same objects as on Microsoft SQL Server. - 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) and physical properties such as [Partition Clause](https://knowledge.bigenius-x.com/partition-clause-and-table-storage-model-object?hsLang=en), Table Compression and tablespaces apply. ### Limitations - A Store Entity has at least one business key and no relationships. - With a Version Valid From Term, a Store Entity allows one dataflow, one dataflow set, no aggregation and no delete detection. - A Store Entity has no unknown-member row; [Custom Singleton Values](https://knowledge.bigenius-x.com/custom-singleton-values-model-object?hsLang=en) is not available. ### Release differences - Generator 2.2: Persist Validity, Delete Detection Partial Terms and Delete Detection Partial Operator are available. - Generator 2.3: Hash Group Size is available on Oracle. ### Related articles - Previous: [Stage](https://knowledge.bigenius-x.com/create-a-stage?hsLang=en), [Store Composite](https://knowledge.bigenius-x.com/create-a-store-composite?hsLang=en) - Next: [Configure delete detection](https://knowledge.bigenius-x.com/configure-a-delete-detection-behavior?hsLang=en), [Configure a multi-version load](https://knowledge.bigenius-x.com/configure-a-multi-version-load?hsLang=en) - Reference: [Historization Type (Term and Relationship)](https://knowledge.bigenius-x.com/historization-type-term-and-relationship?hsLang=en), [Delta Detection (Model Object)](https://knowledge.bigenius-x.com/delta-detection-model-object?hsLang=en), [Load Caching (Model Object)](https://knowledge.bigenius-x.com/load-caching-model-object?hsLang=en), [Version Valid From Term (Dataflow Model Object)](https://knowledge.bigenius-x.com/validfrom-source-term-dataflow-model-object?hsLang=en), [Persist Validity (Project)](https://knowledge.bigenius-x.com/persist-validity-project?hsLang=en), [Hash Group Size (Model Object)](https://knowledge.bigenius-x.com/hash-group-size-model-object?hsLang=en), [BG\_UpdateTimestamp](https://knowledge.bigenius-x.com/bg_updatetimestamp?hsLang=en), [BG\_ValidFromTimestamp](https://knowledge.bigenius-x.com/bg_validfromtimestamp?hsLang=en), [BG\_ValidToTimestamp](https://knowledge.bigenius-x.com/bg_validtotimestamp?hsLang=en), [BG\_RowHashScd1](https://knowledge.bigenius-x.com/bg_rowhashscd1?hsLang=en), [BG\_RowHashScd2](https://knowledge.bigenius-x.com/bg_rowhashscd2?hsLang=en), [BG\_IsDeleted](https://knowledge.bigenius-x.com/bg_isdeleted?hsLang=en) - See also: [Change detection and historization](https://knowledge.bigenius-x.com/change-detection-and-historization?hsLang=en), [How biGENIUS-X builds hash values](https://knowledge.bigenius-x.com/how-bigenius-x-builds-hash-values?hsLang=en), [Create a Model Object with the wizard](https://knowledge.bigenius-x.com/create-a-model-object-with-the-wizard?hsLang=en), [Model a Data Store Solution](https://knowledge.bigenius-x.com/model-a-data-store-solution?hsLang=en), [Supported Load Cachings (Business Rule)](https://knowledge.bigenius-x.com/supported-load-cachings-business-rule?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