Textual Facts in the fact table

View previous topic View next topic Go down

Textual Facts in the fact table

Post  bandik on Thu Jun 24, 2010 3:23 pm

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.

bandik

Posts : 4
Join date : 2010-06-24

View user profile

Back to top Go down

Re: Textual Facts in the fact table

Post  John Simon on Thu Jun 24, 2010 6:31 pm

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 Simon

Posts : 186
Join date : 2009-05-29
Location : Melbourne, Australia

View user profile http://jsimonbi.wordpress.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