KPIZME

 Profile Answers by KPIZME Questions by KPIZME

• May 25th, 2006

 

Basically speaking, Inmon professes the Snowflake Schema while Kimball relies on the Star Schema

swathi tirumala

• May 26th, 2006

 

Both differed in the concept of building teh datawarehosue..

According to Kimball ...

Kimball views data warehousing as a constituency of data marts. Data marts are focused on delivering business objectives for departments in the organization. And the data warehouse is a conformed dimension of the data marts. Hence a unified view of the enterprise can be obtain from the dimension modeling on a local departmental level.

Inmon beliefs in creating a data warehouse on a subject-by-subject area basis. Hence the development of the data warehouse can start with data from the online store. Other subject areas can be added to the data warehouse as their needs arise. Point-of-sale (POS) data can be added later if management decides it is necessary.

 

i.e.,

Kimball--First DataMarts--Combined way ---Datawarehouse

Inmon---First Datawarehouse--Later----Datamarts

swathi

• May 26th, 2006

 

hi all

the main difference b/w the kimball and inmon technologies is..

Kimball --- creating datamarts first then combining tehm up to form a datawarehouse

Inmon----Creating datawarehouse --- then datamarts

Mayee

• Jun 8th, 2006

 

Actually, the main difference is Kimball: fallows Dimentional ModellingInmon: fallows ER ModellingbyeMayee

saivenkatesh

 Profile Answers by saivenkatesh 

• Jun 22nd, 2006

 

RalfKimball: he follows bottum-up approach i.e., first create individual Data Marts from the existing sources and then create Data Warehouse.

BillImmon: he follows top-down approach i.e., first create Data Warehouse from the existing sources and then create individual Dat Marts.