Textual Fact - Junk Dimension

View previous topic View next topic Go down

Textual Fact - Junk Dimension

Post  darylm74 on Tue Jun 04, 2013 9:06 am

Is there ever a case where you leave textual facts in place in the fact instead of a junk dimension? Right now I am looking at breaking them out into a junk dimension but a couple things have me questioning if that is correct. First is that the textual facts are populated on the details heavily so probably 95% of the time, and usually no more than 30-50 bytes. The second is most of our reports dump out detail along with the aggregations. If I am already retrieving all of the data anyway, does creating a fact with a junk dimension that would be roughly the same size as the fact really make sense?

darylm74

Posts : 7
Join date : 2012-09-17

View user profile

Back to top Go down

Re: Textual Fact - Junk Dimension

Post  BoxesAndLines on Tue Jun 04, 2013 11:05 am

I would consider leaving the column in the fact table under those circumstances.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum