Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Fact or Profile dim for indicators ?

4 posters

Go down

Fact or Profile dim for indicators ? Empty Fact or Profile dim for indicators ?

Post  VTK 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

Back to top Go down

Fact or Profile dim for indicators ? Empty Re: Fact or Profile dim for indicators ?

Post  thedude 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

Back to top Go down

Fact or Profile dim for indicators ? Empty Re: Fact or Profile dim for indicators ?

Post  ngalemmo 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.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Fact or Profile dim for indicators ? Empty Re: Fact or Profile dim for indicators ?

Post  VTK 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

Back to top Go down

Fact or Profile dim for indicators ? Empty Re: Fact or Profile dim for indicators ?

Post  Jeff Smith 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

Back to top Go down

Fact or Profile dim for indicators ? Empty Re: Fact or Profile dim for indicators ?

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum