Re: To-Date Calculations

From: Steven Hauser <hause011_at_garnet.tc.umn.edu>
Date: 1 Oct 2000 23:08:04 -0500
Message-ID: <8r91n4$k9$1@garnet.tc.umn.edu>

Use what is known as a date dimension in datawarehouse lingo.

That is the precalculated table of date values to join with the large fact table. One attribute of daily dates can be used to create the other attributes of weeks, months, quarters, business quarters, days of week, etc using the date functions in Oracle.

Read the Data Warehouse Toolkit by Ralph Kimball for reasons you would do this.

-- 


---------------------------------------------------------

Steven Hauser 
email: hause011@tc.umn.edu   URL: http://www.tc.umn.edu/~hause011


---------------------------------------------------------

Received on Sun Oct 01 2000 - 23:08:04 CDT