I am trying to create a dimensional model in order to model a work process. The only thing that is confusing is that I have an addtribute that is really a bunch of dates. It is a status field date that updates as one of the statuses on the transaction updates. What I am wondering is if this belongs in the fact table or in a separate Dimension.


ie.
status dimension
Status_Key
Status_Description
Status_Change_Date1
Status_Change_Date2
Statis_Change_Date3


or


Fact
Status_Key
Status_Change_Date1
Status_Change_Date2
Status_Change_Date3


PLEASE HELP! Any resource suggestions are appreciated