Hi,
I am new in designing a data warehouse. Does it makes sense to have a
dimension table called AGE where maybe numbers from 10 - 100 are in it?
Maybe I should callculate the age in my query ?! I think it is OK to
have a TIME dimension wich is responisble for the birthday, and other
dates in the fact table.
thanks for every hint
I usually calculate age in the warehouse (dim table or atribute). My clients
simply didnt need 'birthday' dimension, they only wanted to know age of the
people involved...
MC
"Andi" <andreas.schneider@.skillworks.de> wrote in message
news:1130851976.246076.278580@.g14g2000cwa.googlegr oups.com...
> Hi,
> I am new in designing a data warehouse. Does it makes sense to have a
> dimension table called AGE where maybe numbers from 10 - 100 are in it?
> Maybe I should callculate the age in my query ?! I think it is OK to
> have a TIME dimension wich is responisble for the birthday, and other
> dates in the fact table.
> thanks for every hint
>
No comments:
Post a Comment