Textual Facts in the fact table
2 posters
Page 1 of 1
Textual Facts in the fact table
Its a new financial 'capital markets' dimensional reporting model (for IPO - raise money for an issuer by issuing new equity common stock securities) that's in design stage. There are some textual attributes of the grain of several fact tables for which there are no related dimensions example 'sales comments', 'broker comments', 'pricing comments' etc. The grain is '1 row per issue per issuer'. These columns are free text fields in front end (OLTP). No complex rollups, slicing etc are intended on these columns but several reports need these columns.
Example : For deal_details_fact table - grain is - 1 row per deal per issuer. The dimensions are issuer, security type, deal country, deal currency date, broker etc.
To accomodate textual facts - I am creating a separate dimension 'Deal_details_Dimension' table where all the textual attributes for the deal is stored.
Is this a good design ?
Any advise here is highly appreciated. Thanks.
Example : For deal_details_fact table - grain is - 1 row per deal per issuer. The dimensions are issuer, security type, deal country, deal currency date, broker etc.
To accomodate textual facts - I am creating a separate dimension 'Deal_details_Dimension' table where all the textual attributes for the deal is stored.
Is this a good design ?
Any advise here is highly appreciated. Thanks.
bandik- Posts : 4
Join date : 2010-06-24
Re: Textual Facts in the fact table
You've hit the nail on the head. Keep those attributes in a dimension table to keep your fact table narrow (and so more performant).
John
John
Similar topics
» Single Attribute Dimensions - why not instead write textual attribute into Fact table?
» Non additive facts in fact table
» Multiple facts in a fact table
» non-additive facts in a fact table?
» Measures in Dimension?
» Non additive facts in fact table
» Multiple facts in a fact table
» non-additive facts in a fact table?
» Measures in Dimension?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum