04::TopDown VS BottomUp(R. Kimbal vs Inmon)

Bill Inmon :(Top-Down Approach)

•Normalized data model

•Enterprise view of data

•Single, central storage of data

•Takes longer to build

•High exposure to risk and failure.

Kimbal :(Bottom-Up Approach)

•De-normalized data model

•Collection of conformed data marts which gives enterprise view

•Inherently incremental

•Less risk of failure and allows project team to learn and grow.