Re: Data Warehouse Suggestions

Hi,



The best books on the subject are The Datawarehouse Toolkit by Ralph Kimball
and Building the Datawarehouse by Bill Inmon.



But my mentor insisted that everything is either a measured fact or a dimensional
attribute.



Good point, the only question left is whether the *OR* between fact and dimension is an excusive or a non exclusive one. IMO this is in a nutshell the difference between Kimball (promoter of exclusive view) and Inmon (a customer attribute is a typical dimension in product selling context but can be also a measure e.g. in a customer scoring context).



Regards



Jaromir D.B. Nemec



http://www.db-nemec.com

----- Original Message ----- From: "Steve Ollig" <sollig@xxxxxxxxxxxxx>
To: <katpopins21@xxxxxxxxx>; <oracle-l@xxxxxxxxxxxxx>
Sent: Thursday, July 14, 2005 5:24 PM
Subject: RE: Data Warehouse Suggestions



--
http://www.freelists.org/webpage/oracle-l

Other related posts: