--- title: Mart Composite description: A Mart Composite joins, filters and calculates source data in the Mart layer for other Mart model objects. --- [Skip to content](https://knowledge.bigenius-x.com/mart-composite#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) # Mart Composite **Applies to** Platform: Microsoft SQL Server · Snowflake · Databricks · Databricks dbt · Fabric Lakehouse · Fabric Warehouse · Oracle Architecture: Data Mart A Mart Composite joins, filters and calculates source data in the Mart layer for other Mart model objects. Use it for logic that several Mart Dimensions, Mart Facts or Mart Outs read, or to prepare the input of a Mart Hierarchy Flatten. With the default Implementation Type `Virtual` it consists of views; with `Cached` it stores its result in a table that each load rebuilds. ### Sources and readers A Mart Composite reads these sources: - Data Mart: Mart Composite and Mart Hierarchy Flatten of the project, and linked objects of a Data Vault, Dimensional (Entity, Fact) or Data Store project (Store Entity). - Vault and Mart: the Raw Vault and Business Vault objects of the project except the RawVault Composite, [Vault Out](https://knowledge.bigenius-x.com/vault-out?hsLang=en), Mart Composite and Mart Hierarchy Flatten. - Dimensional and Mart (not on Databricks dbt and Oracle): Entity, Fact, Mart Composite, Mart Hierarchy Flatten and linked Store Entity. A BusinessVault Composite as source raises the validation warning ID-21002, see [Composite model object from another layer (Business Rule)](https://knowledge.bigenius-x.com/composite-model-object-from-another-layer-business-rule?hsLang=en). Its message refers to the [Vault Out](https://knowledge.bigenius-x.com/vault-out?hsLang=en). A Mart Composite has no relationships. [Mart Dimension](https://knowledge.bigenius-x.com/mart-dimension?hsLang=en), [Mart Fact](https://knowledge.bigenius-x.com/mart-fact?hsLang=en), Mart Composite, [Mart Hierarchy Flatten](https://knowledge.bigenius-x.com/mart-hierarchy-flatten?hsLang=en) and [Mart Out](https://knowledge.bigenius-x.com/mart-out?hsLang=en) can read it. ### Create a Mart Composite - With the wizard: open the menu of the source model object, choose **Automate** and then **Create Mart Composite**. See [Create a Model Object with the wizard](https://knowledge.bigenius-x.com/create-a-model-object-with-the-wizard?hsLang=en). The wizard is not offered on a RawVault Composite, BusinessVault Composite, Hierarchy Flatten or Mart Hierarchy Flatten. - Manually: [create a model object](https://knowledge.bigenius-x.com/create-a-model-object?hsLang=en) of type Mart Composite in the Datamart 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). Joins, the filter of the dataflow set and term expressions define the result. A Mart Composite has exactly one dataflow; several dataflow sets in it are combined with a set operator such as `UNION ALL`. ### Properties - [Implementation Type](https://knowledge.bigenius-x.com/implementation-type-model-object?hsLang=en): `Virtual` (default) or `Cached`. `Virtual` creates views only, so readers always see the current source data. `Cached` adds a table and a loader that empties the table and inserts all rows of the source view on every load. - [Deduplication Method](https://knowledge.bigenius-x.com/deduplication-method-dataflow?hsLang=en) (`None`, `Distinct`, `Partition`) and [Sort Order within Partition](https://knowledge.bigenius-x.com/sort-order-within-partition-dataflow?hsLang=en). `Partition` keeps one row per business key. ### Default Terms - [`BG_LoadTimestamp`](https://knowledge.bigenius-x.com/bg_loadtimestamp?hsLang=en): with `Cached`, the load that wrote the rows. With `Virtual`, the result view returns NULL. - [`BG_SourceSystem`](https://knowledge.bigenius-x.com/bg_sourcesystem?hsLang=en): empty unless you map it. ### Generated objects These are the names on Microsoft SQL Server for a Mart Composite `employee_manager`: | Role | Generated name | Purpose | | --- | --- | --- | | Source | `DM_MC_employee_manager_Source` | Joins and maps the sources | | Deduplication | `DM_MC_employee_manager_Deduplication` | Removes duplicate rows | | Loader | `DM_MC_employee_manager_Loader` | Reloads the table | | Storage | `DM_MC_employee_manager` | Composite table | | Result | `DM_MC_employee_manager_Result` | View for the readers | - The loader is a stored procedure and the composite table a table; the other objects are views. - Loader and table exist only with `Cached`. With `Virtual`, the result view reads the views instead of a table. - The deduplication view exists only with a Deduplication Method other than `None`. Without deduplication, the dependencies are: ``` Virtual: sources -> _Source -> _Result -> readers Cached: sources -> _Source -> _Loader _Loader -> DM_MC_employee_manager -> _Result ``` ### Example The Mart Composite `employee_manager` on Microsoft SQL Server reads the Business Current View `EMPLOYEE` and maps `EMPLOYEE_ID` (business key), `MANAGER_ID` and `LAST_NAME`. Its Implementation Type is `Cached`. The first load on 2026-10-28 at 10:00 reads these employees: ``` EMPLOYEE_ID MANAGER_ID LAST_NAME 401 NULL Keller 405 401 Huber 416 405 Meier 420 416 Brunner ``` Before the load at 12:00, employee 405 changes the last name to Huber-Graf, and employee 416 now reports to 401. ### Check the result Query the result view, here in the schema `mart`: ``` SELECT EMPLOYEE_ID, MANAGER_ID, LAST_NAME, BG_LoadTimestamp FROM mart.DM_MC_employee_manager_Result ORDER BY EMPLOYEE_ID; ``` This is the result after the load at 12:00, with a shortened timestamp: ``` EMPLOYEE_ID MANAGER_ID LAST_NAME LoadTs 401 NULL Keller 2026-10-28 12:00 405 401 Huber-Graf 2026-10-28 12:00 416 401 Meier 2026-10-28 12:00 420 416 Brunner 2026-10-28 12:00 ``` - The loader emptied the table and inserted all four employees again, so every row has the load timestamp of 12:00. - The table shows the current source values; the values of the first load are gone. ### Platform differences - Snowflake: names are in capitals, and the composite table is a transient table. The load control task `LC_DM_MC__TASK` calls the loader. The dataflow properties [Use Stream](https://knowledge.bigenius-x.com/use-stream-model-object?hsLang=en) (not with `Virtual`) 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 `DM_MC__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) and [Optimization Method Columns](https://knowledge.bigenius-x.com/optimization-method-columns-model-object?hsLang=en) apply. - Databricks dbt: the generator creates `dm_mc__source` (view, including the deduplication) and `dm_mc__result` (view, only with [Create Result Views](https://knowledge.bigenius-x.com/create-result-views-project?hsLang=en) on). With `Cached`, the table model `dm_mc_` is added. The properties File Format, Optimization Method and Optimization Method Columns apply. - Oracle: the properties Create Table Statistics, Parallel Degree of Statistics Calculation, Table Compression, Tablespace Table, Tablespace Index and [Partition Clause](https://knowledge.bigenius-x.com/partition-clause-and-table-storage-model-object?hsLang=en) apply. ### Limitations - A Mart Composite has exactly one dataflow with one or more dataflow sets. - It has no relationships and at least one term that is not a Default Term. ### Related articles - Next: [Mart Dimension](https://knowledge.bigenius-x.com/mart-dimension?hsLang=en), [Mart Fact](https://knowledge.bigenius-x.com/mart-fact?hsLang=en), [Mart Hierarchy Flatten](https://knowledge.bigenius-x.com/mart-hierarchy-flatten?hsLang=en), [Mart Out](https://knowledge.bigenius-x.com/mart-out?hsLang=en) - Reference: [Implementation Type (Model Object)](https://knowledge.bigenius-x.com/implementation-type-model-object?hsLang=en), [Deduplication Method (Dataflow)](https://knowledge.bigenius-x.com/deduplication-method-dataflow?hsLang=en), [Sort Order within Partition (Dataflow)](https://knowledge.bigenius-x.com/sort-order-within-partition-dataflow?hsLang=en), [BG\_LoadTimestamp](https://knowledge.bigenius-x.com/bg_loadtimestamp?hsLang=en), [BG\_SourceSystem](https://knowledge.bigenius-x.com/bg_sourcesystem?hsLang=en), [Composite model object from another layer (Business Rule)](https://knowledge.bigenius-x.com/composite-model-object-from-another-layer-business-rule?hsLang=en) - See also: [Create a Model Object with the wizard](https://knowledge.bigenius-x.com/create-a-model-object-with-the-wizard?hsLang=en), [Vault Out](https://knowledge.bigenius-x.com/vault-out?hsLang=en), [Model a Data Mart Solution](https://knowledge.bigenius-x.com/model-a-data-mart-solution?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