---
title: Mart Out
description: A Mart Out is a model object type of the Mart layer that combines Mart objects into one output that is read after the star schema.
---

[Skip to content](https://knowledge.bigenius-x.com/create-a-mart-out#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 Out

**Applies to**  
Platform: Microsoft SQL Server · Snowflake · Databricks · Databricks dbt · Fabric Lakehouse · Fabric Warehouse · Oracle  
Architecture: Data Mart

A Mart Out is a model object type of the Mart layer that combines Mart objects into one output that is read after the star schema. Use it as the final object that consumers query, or as the source of another Mart Out. With Implementation Type `Virtual` you get views only; with `Cached` you also get a table that each load fills again.

Available since Generator 2.2. A Mart Out reads only Mart objects, also in Vault and Mart and in Dimensional and Mart projects.

### Sources and consumers

A Mart Out reads these model object types:

- [Mart Composite](https://knowledge.bigenius-x.com/create-a-mart-composite?hsLang=en), [Mart Dimension](https://knowledge.bigenius-x.com/create-a-mart-dimension?hsLang=en), [Mart Fact](https://knowledge.bigenius-x.com/create-a-mart-fact?hsLang=en) and [Mart Hierarchy Flatten](https://knowledge.bigenius-x.com/create-a-mart-hierachy-flatten?hsLang=en) of the project.
- Another Mart Out of the project.
- In a Data Mart project, a Mart Out that you [imported](https://knowledge.bigenius-x.com/import-a-project-to-be-used-as-a-linked-project?hsLang=en) from another project through Data Connections. The source view reads its result view `DM_MO_<model object name>_Result` through the placeholders `{<project identifier>#<import name>#database_name}`, `schema_name` and `server_name`, which you set when you replace the placeholders. Nothing is generated for the imported Mart Out itself.

Raw Vault, Business Vault, Dimensional and Data Store objects, PITs and linked objects other than a Mart Out are not valid sources. A Vault Out is not a valid source either.

Among model objects, only another Mart Out can use a Mart Out as source. A Mart Out has no relationships.

### Create a Mart Out

- With the wizard: open the menu of a Mart Composite, Mart Dimension, Mart Fact, Mart Hierarchy Flatten or Mart Out, choose **Automate** and then **Create Mart Out**. The steps are Create Model Object, Create Dataflow, Map Selected Terms and Add to View; see [Create a Model Object with the wizard](https://knowledge.bigenius-x.com/create-a-model-object-with-the-wizard?hsLang=en). Implementation Type is preset to `Virtual`. Map Selected Terms lists the terms of the source with their data type and business-key flag; select the terms the Mart Out gets.
- Manually: [create a model object](https://knowledge.bigenius-x.com/create-a-model-object?hsLang=en) of type Mart Out in the Mart layer, [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).

A Mart Out has exactly one dataflow. Join several sources in its dataflow set, or combine dataflow sets with a set operator.

### Properties

- [Implementation Type](https://knowledge.bigenius-x.com/implementation-type-model-object?hsLang=en): `Virtual` (default) or `Cached`. `Virtual` creates views only, so the result view reads the sources at query time. `Cached` adds a table and a loader. The loader empties the table and inserts all rows again on every load.
- [Deduplication Method](https://knowledge.bigenius-x.com/deduplication-method-model-object?hsLang=en), set per dataflow: `None` (default), `Distinct` or `Partition`. `Distinct` removes rows that are equal in all terms. `Partition` keeps one row per business key, the first one by Sort Order within Partition.
- [Sort Order within Partition](https://knowledge.bigenius-x.com/deduplication-partition-model-object?hsLang=en), set per dataflow: the order that decides which row `Partition` keeps.

Edit Term offers the Business Key flag on Mart Out terms. Only `Partition` uses it. Without business keys, `Partition` partitions by all terms that are not Default Terms, which removes the same rows as `Distinct`, and validation shows warning ID-10051.

### Default Terms

- [`BG_LoadTimestamp`](https://knowledge.bigenius-x.com/bg_loadtimestamp?hsLang=en): with `Cached`, the loader writes the load timestamp. In a `Virtual` Mart Out it is NULL unless you map it.
- [`BG_SourceSystem`](https://knowledge.bigenius-x.com/bg_sourcesystem?hsLang=en): NULL unless you map it.

The wizard maps neither of them.

### Generated objects

These are the names on Microsoft SQL Server for a Mart Out `sales_mo`:

| Role | Generated name | Purpose |
| --- | --- | --- |
| Source | `DM_MO_sales_mo_Source` | Joins the sources |
| Deduplication | `DM_MO_sales_mo_Deduplication` | Removes duplicates |
| Storage | `DM_MO_sales_mo` | Table |
| Loader | `DM_MO_sales_mo_Loader` | Reloads the table |
| Result | `DM_MO_sales_mo_Result` | Query view |

- The loader is a stored procedure and the table is a table; all other objects are views.
- The source view reads the result views of the sources, for example `DM_MD_<model object name>_Result` of a Mart Dimension.
- The deduplication view exists only with `Distinct` or `Partition`.
- The table and the loader exist only with `Cached`. Load control runs the loader after the loaders of the sources.
- The result view reads the table with `Cached`, otherwise the deduplication or source view.

```
sources -> _Source -> _Deduplication (Distinct or Partition)
Cached:  last view -> _Loader -> DM_MO_sales_mo -> _Result
Virtual: last view -> _Result
```

### Example

Two Mart Outs on Microsoft SQL Server, in the schema `m`:

- `sales_mo` reads `QUANTITY` and `TRANSACTION_TIME` of the Mart Dimension `common_salestransaction`. Implementation Type is `Cached` and Deduplication Method is `Distinct`.
- `sales_report_mo` reads the same terms from `sales_mo` with Implementation Type `Virtual`.

The Default Terms are not mapped. The result view of the Mart Dimension delivers three rows: quantity 2 at 2026-04-01 10:00 twice and quantity 5 at 11:00. After the loader of `sales_mo` ran at 2026-04-02 06:00, query both result views:

```
SELECT QUANTITY, TRANSACTION_TIME, BG_LoadTimestamp, BG_SourceSystem
FROM m.DM_MO_sales_mo_Result ORDER BY QUANTITY;
SELECT QUANTITY, TRANSACTION_TIME, BG_LoadTimestamp, BG_SourceSystem
FROM m.DM_MO_sales_report_mo_Result ORDER BY QUANTITY;
```

This is the result, with the timestamps shortened. `Distinct` keeps the two equal rows of quantity 2 once:

```
sales_mo
QUANTITY  TRANSACTION_TIME  BG_LoadTimestamp  BG_SourceSystem
2.000     2026-04-01 10:00  2026-04-02 06:00  NULL
5.000     2026-04-01 11:00  2026-04-02 06:00  NULL

sales_report_mo
QUANTITY  TRANSACTION_TIME  BG_LoadTimestamp  BG_SourceSystem
2.000     2026-04-01 10:00  NULL              NULL
5.000     2026-04-01 11:00  NULL              NULL
```

Then the Mart Dimension stops delivering the row with quantity 5. `sales_report_mo` still returns both rows, because it reads the table of `sales_mo`. The loader of `sales_mo` at 2026-04-03 06:00 reports 1 inserted row, the two equal rows counted once. Afterwards the same queries return:

```
sales_mo
QUANTITY  TRANSACTION_TIME  BG_LoadTimestamp  BG_SourceSystem
2.000     2026-04-01 10:00  2026-04-03 06:00  NULL

sales_report_mo
QUANTITY  TRANSACTION_TIME  BG_LoadTimestamp  BG_SourceSystem
2.000     2026-04-01 10:00  NULL              NULL
```

### Platform differences

- Snowflake: names are in upper case, and the table is transient. The loader overwrites the table, and the load control task `LC_DM_MO_<MODEL OBJECT NAME>_TASK` calls it; a `Virtual` Mart Out has no task. 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 `DM_MO_<model object name>_Loader` and overwrites the table. 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 the dbt models `dm_mo_<model object name>_source` (view, with the deduplication inside), `dm_mo_<model object name>` (table, only with `Cached`) and `dm_mo_<model object name>_result` (view, only with [Create Result Views](https://knowledge.bigenius-x.com/create-result-views-project?hsLang=en) on). There is no loader. File Format, Optimization Method and Optimization Method Columns apply.
- Oracle: the properties Partition Clause, Table Compression, Create Table Statistics, Parallel Degree of Statistics Calculation, Tablespace Table and Tablespace Index apply to the table.

### Limitations

- A Mart Out has exactly one dataflow, at least one term that is not a Default Term, and no relationships.
- Implementation Type `Permanent` and Deduplication Method `Condensing` fail validation.
- A `Cached` Mart Out keeps no history: each load replaces all rows.

### Related articles

- Next: [Generate artifacts](https://knowledge.bigenius-x.com/generate-artifacts?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-model-object?hsLang=en), [Sort Order within Partition (Dataflow)](https://knowledge.bigenius-x.com/deduplication-partition-model-object?hsLang=en), [BG\_LoadTimestamp](https://knowledge.bigenius-x.com/bg_loadtimestamp?hsLang=en), [BG\_SourceSystem](https://knowledge.bigenius-x.com/bg_sourcesystem?hsLang=en) 
    - Snowflake: [Use Stream (Model Object)](https://knowledge.bigenius-x.com/use-stream-model-object?hsLang=en)
    - Databricks: [File Format (Model Object)](https://knowledge.bigenius-x.com/file-format-model-object?hsLang=en), [Optimization Method (Model Object)](https://knowledge.bigenius-x.com/optimization-method-model-object?hsLang=en), [Optimization Method Columns (Model Object)](https://knowledge.bigenius-x.com/optimization-method-columns-model-object?hsLang=en)
    - Databricks dbt: [File Format (Model Object)](https://knowledge.bigenius-x.com/file-format-model-object?hsLang=en), [Optimization Method (Model Object)](https://knowledge.bigenius-x.com/optimization-method-model-object?hsLang=en), [Optimization Method Columns (Model Object)](https://knowledge.bigenius-x.com/optimization-method-columns-model-object?hsLang=en)
    - Fabric Lakehouse: [File Format (Model Object)](https://knowledge.bigenius-x.com/file-format-model-object?hsLang=en), [Optimization Method (Model Object)](https://knowledge.bigenius-x.com/optimization-method-model-object?hsLang=en), [Optimization Method Columns (Model Object)](https://knowledge.bigenius-x.com/optimization-method-columns-model-object?hsLang=en)
    - Oracle: [Partition Clause and table storage (Model Object)](https://knowledge.bigenius-x.com/partition-clause-and-table-storage-model-object?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), [Mart Composite](https://knowledge.bigenius-x.com/create-a-mart-composite?hsLang=en), [Mart Dimension](https://knowledge.bigenius-x.com/create-a-mart-dimension?hsLang=en), [Mart Fact](https://knowledge.bigenius-x.com/create-a-mart-fact?hsLang=en), [Mart Hierarchy Flatten](https://knowledge.bigenius-x.com/create-a-mart-hierachy-flatten?hsLang=en), [Vault Out](https://knowledge.bigenius-x.com/create-a-vault-out?hsLang=en), [Use Linked Projects](https://knowledge.bigenius-x.com/use-linked-projects?hsLang=en), [Import a Project to be used as a Linked Project](https://knowledge.bigenius-x.com/import-a-project-to-be-used-as-a-linked-project?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)

<https://www.linkedin.com/company/bigenius> <https://www.youtube.com/@biGENIUS_DWA>

All rights reserved © 2025, biGENIUS AG