Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Textual Fact - Junk Dimension

2 posters

Go down

Textual Fact - Junk Dimension Empty Textual Fact - Junk Dimension

Post  darylm74 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

Back to top Go down

Textual Fact - Junk Dimension Empty Re: Textual Fact - Junk Dimension

Post  BoxesAndLines Tue Jun 04, 2013 11:05 am

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

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

Back to top Go down

Back to top

- Similar topics

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