Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
learntsql
524 Posts |
 Posted - 2010-06-12 : 09:52:29
|
| Hi All,Can we have Descriptive values in fact table?for eg; i want to analyze data based on remarks entered for any product.Is this the right way?What is the best practice?please guide me.TIA. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2010-06-14 : 04:13:53
|
| If you can make it into a measure then it shouldn't be a problem, but it would be better to have a surrogate key in the fact table and the description in a dimension, this way, you are keeping your fact as small as possible as well as keeping everything in line with a DW design. |
 |
|
|
learntsql
524 Posts |
Posted - 2010-06-14 : 04:24:21
|
| Thank you RickD. |
|
|
|
|
|
|
Descriptive values in fact table?