manickam (10/5/2013)
2. Actually issues will be associated with many deatiled text and lattributes. Do we need to capture this information in the FACT_ISSUE table as per this model. As of now we planned to move those information to another table called Dimension_Issue (though we cannot call it as dimension since its not repitative data in the fact table).
For point #2, it sounds like you're on the right track; you could create a degenerate dimension that has the issue text in it. You could put it right in the fact table, but since it's probably large I'd consider moving it to a separate dimension table.
http://www.kimballgroup.com/2003/06/03/design-tip-46-another-look-at-degenerate-dimensions/
HTH,
Rob