Re: Design question
Date: Fri, 20 Feb 2009 20:56:08 +0100
Message-ID: <499f0a59$0$2848$ba620e4c_at_news.skynet.be>
"Mladen Gogala" <gogala.mladen_at_gmail.com> wrote in message
news:gnebgm$hfl$2_at_solani.org...
> On Tue, 17 Feb 2009 00:57:55 -0800, matthias.hoys wrote:
>
>> Would this be ok:
>> - dimension table "Location'
>> - dimension table "Time"
>> - dimension table "Temperature"
>> - fact table "Measurements": location_id, time_id, maxtemperature_id,
>> mintemperature_id etc ...
>
> Probably the best design yet. Yes, this looks right.
>
>
>
> --
> http://mgogala.freehostia.com
I have an additional question regarding the "Temperature" dimension. These are values like 10.34, 25.40, -0.19 ... so these are floating point values with a precision of 2 numbers.Should I create a separate dimension for this attribute (with foreign keys mintemperature_id, maxtemperature_id in the Facts table) or just put them as such in the facts table ? I don't see the real advantage of creating a separate dimension for them ?
Matthias Received on Fri Feb 20 2009 - 13:56:08 CST