GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Basics
Go To First  |  Previous Question  |  Next Question 
 Basics  |  Question 61 of 111    Print  
What is the main difference between Inmon and Kimball philosophies of data warehousing?

  
Total Answers and Comments: 5 Last Update: June 22, 2006     Asked by: MF 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
May 25, 2006 18:11:02   #1  
KPIZME Member Since: May 2006   Contribution: 8    

RE: What is the main difference between Inmon and Kimb...
Basically speaking, Inmon professes the Snowflake Schema while Kimball relies on the Star Schema
 
Is this answer useful? Yes | No
May 26, 2006 09:53:50   #2  
swathi tirumala        

RE: What is the main difference between Inmon and Kimb...

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


 
Is this answer useful? Yes | No
May 26, 2006 10:11:57   #3  
swathi        

RE: What is the main difference between Inmon and Kimb...

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


 
Is this answer useful? Yes | No
June 08, 2006 07:41:31   #4  
Mayee        

RE: What is the main difference between Inmon and Kimb...
Actually, the main difference is Kimball: fallows Dimentional ModellingInmon: fallows ER ModellingbyeMayee
 
Is this answer useful? Yes | No
June 22, 2006 06:11:30   #5  
saivenkatesh Member Since: June 2006   Contribution: 11    

RE: What is the main difference between Inmon and Kimb...

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.  


 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape