Free Form Text Attribute in Fact Table
2 posters
Page 1 of 1
Free Form Text Attribute in Fact Table
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
Re: Free Form Text Attribute in Fact Table
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.
Similar topics
» Calculating Fact table sizes and free form text
» Free form text in transaction table
» Handling multiple free form text comments
» Free text fields in Transaction table
» Single Attribute Dimensions - why not instead write textual attribute into Fact table?
» Free form text in transaction table
» Handling multiple free form text comments
» Free text fields in Transaction table
» Single Attribute Dimensions - why not instead write textual attribute into Fact table?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum