Fact or Profile dim for indicators ?

View previous topic View next topic Go down

Fact or Profile dim for indicators ?

Post  VTK on Mon Jan 28, 2013 11:48 am

I have a star schema with few (5 to 10) indicator fields(0 or 1 values) and we are debating what's the best place to place them. Fact or Junk dim ? IMO, it's easy to sum them up if it's in the fact table but if that junk dimension is going to be used in multiple stars then it's better to put in junk dim. Is this correct assumption ? I also think junk dim's should be pertained to a single star. Is this correct ? What is rule ofm thumb on this item ? Any input is appreiated.

Thanks

VTK

Posts : 50
Join date : 2011-07-15

View user profile

Back to top Go down

Re: Fact or Profile dim for indicators ?

Post  thedude on Mon Jan 28, 2013 11:53 am

As these are attributes they belong in a dimension, you should only place a degenerate attribute in the fact table.

thedude

Posts : 21
Join date : 2009-02-03
Location : London

View user profile

Back to top Go down

Re: Fact or Profile dim for indicators ?

Post  ngalemmo on Mon Jan 28, 2013 12:59 pm

Keep to the dimensional form. A junk dimension is just as valid as any other dimension and may be used in other facts.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Fact or Profile dim for indicators ?

Post  VTK on Mon Jan 28, 2013 2:52 pm

Thanks for the reply. So, usability in many facts is the key reason that these indicators need to be in the Junk dimension or anything else ? Reason for the question is that these are also kind of additive facts so why can't we keep them in the fact ? so, does kinbam says that all the indicators need to be in dimensions ?

VTK

Posts : 50
Join date : 2011-07-15

View user profile

Back to top Go down

Re: Fact or Profile dim for indicators ?

Post  Jeff Smith on Mon Jan 28, 2013 5:59 pm

First of all, the Indicators need to be supplemented with more meaning information. I user doesn't know what 1/0 means and a report isn't going to be very informative with counts of 1 and 0. Add columns for each indicator that have more meaning when appearing on a report.

The Indicators shouldn't be in the Fact because they aren't measures or dimension keys.

A junk dimension can pertain to any fact table that is appropriate. Say you are a bank and you have a junk dimension for accounts that hangs off you Account Fact. The same junk dimension can be applied to your teller or ATM transaction fact table.

Jeff Smith

Posts : 471
Join date : 2009-02-03

View user profile

Back to top Go down

Re: Fact or Profile dim for indicators ?

Post  Sponsored content


Sponsored content


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