2 docs tagged with "Dimensional"

Dimensional modeling is the standard technique for structuring data warehouses for analytical queries. It organizes data into fact tables and dimension tables to optimize read performance and business usability.

Slowly Changing Dimensions (SCD) handle the problem of dimension attributes that change over time. The chosen SCD type determines how historical values are preserved or overwritten.