Free form text in transaction table

View previous topic View next topic Go down

Free form text in transaction table

Post  vermarajiv on Tue Mar 09, 2010 12:49 pm

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

vermarajiv

Posts : 7
Join date : 2009-12-14

View user profile

Back to top Go down

Re: Free form text in transaction table

Post  ngalemmo on Tue Mar 09, 2010 2:03 pm

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
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Free form text in transaction table

Post  vermarajiv on Tue Mar 09, 2010 2:35 pm

Thats brilliant. Thanks ngalemmo.

vermarajiv

Posts : 7
Join date : 2009-12-14

View user profile

Back to top Go down

Re: Free form text in transaction table

Post  Sponsored content


Sponsored content


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