Datamart
Overview
Data mart is a schema type that contains analytical dimension, fact, and related semantic structures.
Function
Use this type when business-facing analytical data must be organized for reporting and OLAP use. Selecting it supports data mart and semantic objects.
When to use
Choose Data mart when business-facing analytical data must be organized for reporting and OLAP use.
Behavior in AnalyticsCreator
| Area | Behavior |
|---|---|
| Configuration | Create the schema in the data mart layer and assign the Data mart type. |
| Processing | Transformations and packages populate dimension and fact tables for analytical use. |
| Output | The schema contains dimensions, facts, hierarchies, partitions, and related analytical metadata. |
Type-specific properties
| Property | Description |
|---|---|
| Layer | Data mart layer containing the schema. |
| Dimension tables | Descriptive analytical structures. |
| Fact tables | Measures and events analyzed through dimensions. |
| OLAP metadata | Hierarchies, partitions, display metadata, and related settings. |
Compatibility and limitations
Dimensions, facts, keys, grain, and semantic metadata must remain consistent.
Relationships
| Related entity | Relationship |
|---|---|
| Schema | The schema type identifies the architectural role of the schema entity. |
| Layer | Schemas belong to layers that organize warehouse processing. |
| Table and transformation | Tables and transformations are created inside schemas according to their intended role. |
