Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in dimensional-modeling

Joining date dimension multiple times? - Kimball's book on Data warehouse and Dimension Modeling

Dimensional modeling on columnar databases

creating dimension surrogate keys

Why should we separate dimension and facts instead of combining both in one table

Type II SCD with entities that merge over time

How to handle late arriving dimension and NULL business key in Kimball Data Mart?

Dimensional Modelling

Naming standards for dimensional modeling

Is facts table in dimensional model is actually a table of events?

Why we use Dimensional Model over Denormalized relational Model?

Why NULL values are mapped as 0 in Fact tables?

audit table vs. Type 2 Slowly Changing Dimension

Dimension for geozones or Lat & Long in data warehouse

How to design a shrunken dimension table for dates in dimensional warehouse and use in SSAS?

Dimension row with multiple attributes

Redshift Performance of Flat Tables Vs Dimension and Facts

joining across multiple fact tables with a dimension in between