Re: Design question
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 17 Feb 2009 17:42:44 +0000 (UTC)
Message-ID: <gnesuk$mod$5_at_solani.org>
On Tue, 17 Feb 2009 00:57:55 -0800, matthias.hoys wrote:
Date: Tue, 17 Feb 2009 17:42:44 +0000 (UTC)
Message-ID: <gnesuk$mod$5_at_solani.org>
On Tue, 17 Feb 2009 00:57:55 -0800, matthias.hoys wrote:
> Some questions:
> - is it better to put the Time as a separate dimension, or can we put it
> as Date column in the Measurements table ?
Ralph Kimball, in his phenomenal book "DW Toolkit" suggests a separate dimension. I did try it on several occasion and have never been sorry.
-- http://mgogala.freehostia.comReceived on Tue Feb 17 2009 - 11:42:44 CST