Faktentabelle (EN)

Concept

Contains numerical measurement values and references dimensions via foreign keys

Architecture

flowchart TD     A[Datenquellen] --> B[ETL-Prozess]     B --> C[Faktentabelle]     C --> D[Dimensionstabellen]     D --> E[OLAP-System]     E --> F[Endbenutzer-Analysen]          subgraph Data Warehouse         C         D     end

In Context

  • Typically used together with dimension tables in a star schema
  • Related to: Dimension table, Data Warehouse, OLAP, Star schema, Snowflake schema
  • Example use: Sales analyses with facts such as quantity, price and discount, linked with dimensions such as product, customer and time
Quelle: AI Generated