Inmon and Kimball

Inmon:

Top-bottom. First have DW, then have DM

Sources -> Stages -> Enterprise Data Warehouse(Centralized, Normalized and Cleaned DW) -> Data Marts.

Keys: Integrate multiple sources into one DW, and use it for multiple Data Marts.

 

Kimball:

Bottom - Top.

Source -> Stage -> Data Mart.

Keys:For Each new Data Mart, source & stage data specifically.

posted @ 2017-02-10 11:07  付小同  阅读(207)  评论(0编辑  收藏  举报