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.
- Posts : 7
Join date : 2011-08-22
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.
Permissions in this forum:You cannot reply to topics in this forum