How to create a Slowly Changing Dimension Type 1 in Data Modeling (Kimball)
How to create a Slowly Changing Dimension Type 1 in Data Modeling (Kimball): a practical step-by-step guide to update a…
4 min
01 Sep 2026
How to create a Slowly Changing Dimension Type 1 in Data Modeling (Kimball): a practical step-by-step guide to update a…
How to create a Bridge Table in Data Modeling (Kimball): a practical step-by-step guide to resolve many-to-many relatio…
How to create a Periodic Snapshot in Data Modeling (Kimball) to store periodic metrics; practical SQL example and valid…
How to create a Conformed Dimension in Data Modeling (Kimball): step-by-step to align dimensions across fact tables and…
How to create an incremental snapshot in Data Modeling (Kimball): practical step-by-step to capture periodic states and…
Accumulating snapshot in Data Modeling (Kimball): practical example to create an accumulating fact table and update the…
Learn how to build a periodic snapshot fact table in SQL: define the grain, create the table, run an idempotent daily l…
Learn how to build a factless fact table in SQL to count events and reveal absences in your data warehouse, with a clea…
Learn how to build a bridge table in SQL to solve many-to-many relationships in a star schema and sum values without do…
Learn how to create a junk dimension in your data warehouse to group low-cardinality flags, simplify the fact table, an…
Learn how to build role-playing dimensions in a star schema: reuse a single date dimension in multiple roles, with SQL …
Learn how to build a date dimension in SQL for your data warehouse: table design, date generation, and linking it to th…
This site uses essential cookies and, with your consent, statistics cookies (Google Analytics) to improve your experience. Cookie Policy