1.Previous
3.Next

The two most important approaches to store data in a warehouse are dimensional and normalized. The dimensional approach uses a star schema as proposed by Ralph Kimball. The normalized approach, also called the third normal form (3NF) is an entity-relational normalized model proposed by Bill Inmon.

Dimensional approach

In a dimensional approach, transaction data

1.Previous
3.Next