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. Otherwise I have to update the AGE
relationship daily.

Thanks for every hint

Hi Andi,

it does make sense because it prevents you from recalculate the age in
your queries. Also it makes it a lot easier to calculate the age at the
time the fact took place because you propbably want to know the age at
the time when the business that you store in your fact table happened
and not the age of the person at the present moment.

sim

Do you need the age at the time of the event you are modeling or do you
the birthdate to calculate the current age? How accurate do you need
to be? Days, months or years?

If you have the time of the event, then either birthdate or age can be
calculated from the other. For example, "On 2005-10-31 Billy Jones
was 10 years old and bought candy.." versus "On 2005-10-31 Billy
Jones who was born in 1995 bought candy.."