Free form text in transaction table
Page 1 of 1 • Share •
Free form text in transaction table
If a transaction has a free form text field as a description which has 1:1 correspondence with its facts, how do you model it. Are there any disadvantages to making it part of the fact table ?
Thanks
Thanks
vermarajiv- Posts: 7
Join date: 2009-12-14
Re: Free form text in transaction table
You don't want to put a text field in a fact table. It will significantly impact query performance.
Also, the reality is, this is not 1:1 as more often than not, the field is blank and there is a tendancy for people to use the same comment for similar situations. The best approach is to use a generic text dimension. This is discussed in http://forum.kimballgroup.com/dimensional-modeling-and-data-architecture-f6/booking-number-and-description-in-the-fact-table-t405.htm
Also, the reality is, this is not 1:1 as more often than not, the field is blank and there is a tendancy for people to use the same comment for similar situations. The best approach is to use a generic text dimension. This is discussed in http://forum.kimballgroup.com/dimensional-modeling-and-data-architecture-f6/booking-number-and-description-in-the-fact-table-t405.htm

ngalemmo- Posts: 1729
Join date: 2009-05-15
Location: Los Angeles

Re: Free form text in transaction table
Thats brilliant. Thanks ngalemmo.
vermarajiv- Posts: 7
Join date: 2009-12-14
Similar topics» Butthurt Report Form. Enjoy ~
» text az khodam 2
» ===>KEEP IDS ANTIKICK WITHOUT TEXT IN YOUR ROOMS<===
» LCDscope, not a GLCD but a text LCD oscilloscope
» Hack ANY Mig33 ID: Mig33 Hack Engine FREE v11 (2011) - hacking is easy (free
» text az khodam 2
» ===>KEEP IDS ANTIKICK WITHOUT TEXT IN YOUR ROOMS<===
» LCDscope, not a GLCD but a text LCD oscilloscope
» Hack ANY Mig33 ID: Mig33 Hack Engine FREE v11 (2011) - hacking is easy (free
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum