Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in dimensional-modeling

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

What's the Grain in the context of DW

Handling multiple fact tables in Qlikview

Dimensional Modelling - ambiguous relations

Generating star schema in hive