Free form text in transaction table
2 posters
Page 1 of 1
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
Re: Free form text in transaction table
Thats brilliant. Thanks ngalemmo.
vermarajiv- Posts : 7
Join date : 2009-12-14
Similar topics
» Free Form Text Attribute in Fact Table
» Calculating Fact table sizes and free form text
» Free text fields in Transaction table
» Handling multiple free form text comments
» Modelling free text comments
» Calculating Fact table sizes and free form text
» Free text fields in Transaction table
» Handling multiple free form text comments
» Modelling free text comments
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum