Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can date be included in the fact table as a measure?

646563Jul 29 2009 — edited Aug 6 2009

Dear All,

I have to migrate a database form relational model to dimensional model. It a kind of human resource database. I don't know what MEASURES should I keep in the fact table. There are only dates, like date the employee joined the institution and the date he will leave. Most of the other fields are non-numeric. well date is also non-numeric but we can calculate the duration the employee worked from these dates.

What do you suggest?

This post has been answered by 686492 on Jul 29 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 3 2009

Added on Jul 29 2009

#data-warehousing, #table, #warehouse-builder

11 comments

3,056 views