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 hintI 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.googlegroups.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
>sql
No comments:
Post a Comment