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 8:49 am

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 10:03 am

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

ngalemmo

Posts: 1729
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 10:35 am

Thats brilliant. Thanks ngalemmo.

vermarajiv

Posts: 7
Join date: 2009-12-14

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