wmilford

 Profile Answers by wmilford 

• Jan 15th, 2009

 

In relational models data is normalized to 1st, 2nd or 3rd Normal form. In dimensional models data is denormalized. The typical design is that of a Star where their is a central fact table containing additive, measurable facts and this central fact table is in relationship  with dimensional tables which generally contain text filters that normally occurs in the WHERE clause of a query.