Re: Timestamp dimensions in a data warehouse
From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 20 Apr 2011 16:27:57 -0700
Message-ID: <BANLkTin_sNadbFL_VKwbsSV-eX+CR-aDsw_at_mail.gmail.com>
On Wed, Apr 20, 2011 at 11:35 AM, Schauss, Peter (IT Solutions) < peter.schauss_at_ngc.com> wrote:
Date: Wed, 20 Apr 2011 16:27:57 -0700
Message-ID: <BANLkTin_sNadbFL_VKwbsSV-eX+CR-aDsw_at_mail.gmail.com>
On Wed, Apr 20, 2011 at 11:35 AM, Schauss, Peter (IT Solutions) < peter.schauss_at_ngc.com> wrote:
>
> Would there be other reasons for putting the date in a dimension table?
>
>
Doing so makes it very easy to base queries on different time granules.
eg. month, week, day of week, quarter, whatever else you can think of
Without the date dimension such queries become quite difficult.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 20 2011 - 18:27:57 CDT