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

Free form text in transaction table

2 posters

Go down

Free form text in transaction table Empty Free form text in transaction table

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

Back to top Go down

Free form text in transaction table Empty Re: Free form text in transaction table

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

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

http://aginity.com

Back to top Go down

Free form text in transaction table Empty Re: Free form text in transaction table

Post  vermarajiv Tue Mar 09, 2010 2:35 pm

Thats brilliant. Thanks ngalemmo.

vermarajiv

Posts : 7
Join date : 2009-12-14

Back to top Go down

Free form text in transaction table Empty Re: Free form text in transaction table

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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