Fact table
Overview
Fact table is a table type that stores measurable events or transactions for analytical use.
Function
Use this type when a data mart requires measures linked to descriptive dimensions. Selecting it participates as a fact object in analytical and model structures.
When to use
Choose Fact table when a data mart requires measures linked to descriptive dimensions.
Behavior in AnalyticsCreator
| Area | Behavior |
|---|---|
| Configuration | Configure measures, keys, dimension references, partitions, and semantic properties. |
| Processing | Warehouse or transformation processes populate fact rows at the selected grain. |
| Output | The table provides measures and dimension relationships for analytical output. |
Type-specific properties
| Property | Description |
|---|---|
| Grain | Level represented by one fact row. |
| Measures | Numeric or aggregatable values exposed by the table. |
| Dimension references | Relationships from the fact to dimension tables. |
| Partitions | Optional analytical partition definitions. |
Compatibility and limitations
Measures and relationships must match the intended grain to avoid incorrect aggregation.
Relationships
| Related entity | Relationship |
|---|---|
| Table | The table type defines the purpose and behavior of the table entity. |
| Schema | The schema type and warehouse architecture influence which table types are normally used. |
| Package | Import, historization, and persisting packages can populate specific table types. |
