Free Form Text Attribute in Fact Table

View previous topic View next topic Go down

Free Form Text Attribute in Fact Table

Post  Tadec on 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

View user profile

Back to top Go down

Re: Free Form Text Attribute in Fact Table

Post  ngalemmo on 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.
avatar
ngalemmo

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

View user profile http://aginity.com

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