Hello,
This is my first post here so hi everyone
I have a question regarding dimensional modeling. I've got myself two of Kimball's books (The DW Toolkit and the SQL 2005 version of it) and I'm trying to analyze some requirements I have to come up with a simple proof-of-concept dimensional model.
I have a dimension table 'equipment' that contains attributes such as name etc. but the equipment has some attributes that change with time. one of them is 'status'. My fact table, 'transaction' contains its attributes. One requirement of the mockup reports I've been seeing is to see the 'status' of an equipment at the time the 'transaction' was made. My question then is how bad it is to put the 'status' in the transaction fact table? It's not an attribute of the fact but I do want to have it at the time the fact is logged. I just don't want to have this information in my dimension since it's bound to change all the time...
Any suggestions are welcome, even if just to reassure me that it's not as bad as I think it is.
Thanks,
Greg
This is my first post here so hi everyone
I have a question regarding dimensional modeling. I've got myself two of Kimball's books (The DW Toolkit and the SQL 2005 version of it) and I'm trying to analyze some requirements I have to come up with a simple proof-of-concept dimensional model.
I have a dimension table 'equipment' that contains attributes such as name etc. but the equipment has some attributes that change with time. one of them is 'status'. My fact table, 'transaction' contains its attributes. One requirement of the mockup reports I've been seeing is to see the 'status' of an equipment at the time the 'transaction' was made. My question then is how bad it is to put the 'status' in the transaction fact table? It's not an attribute of the fact but I do want to have it at the time the fact is logged. I just don't want to have this information in my dimension since it's bound to change all the time...
Any suggestions are welcome, even if just to reassure me that it's not as bad as I think it is.
Thanks,
Greg