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 Attribute in Fact Table

2 posters

Go down

Free Form Text Attribute in Fact Table Empty Free Form Text Attribute in Fact Table

Post  Tadec Fri May 25, 2012 1:22 pm

There is a text field that is used to give additional location information by customer in regards to their deliveries. Since it is a free from text field and is difficult to maintian consistent and standard values the thought was leave it in the fact table. My feeling is this is incorrect. Can anyone provide me with a sound rational for leaving it in the fact table.

Tadec

Posts : 7
Join date : 2011-08-22

Back to top Go down

Free Form Text Attribute in Fact Table Empty Re: Free Form Text Attribute in Fact Table

Post  ngalemmo Fri May 25, 2012 2:46 pm

It is not a good place to put text fields. If you define it as a CLOB and the database allows you to store CLOBs in a separate data structure, you can get away with it. You do not want to overburden queries that do not use the value with a large bloated fact table that performs poorly.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Back to top

- Similar topics

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