Re: tricky pivot query

From: Jared Still <>
Date: Wed, 11 Jun 2008 09:19:37 -0700
Message-ID: <>

On Tue, Jun 10, 2008 at 10:10 PM, Anthony Wilson <> wrote:

> Argh!! Why don't people store dates as DATESs???

It's perfectly normal (yes, that was a pun) to store dates in this manner in a DW environment.

That said, the way it was done in this example wasn't so good.

It would be better if the date were stored with the data, and the day_id, month_id, etc, were stored in a separate date table.

See Kimball's "Data Warehouse Toolkit" for a good example of that.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Received on Wed Jun 11 2008 - 11:19:37 CDT

Original text of this message