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

Outrigger dimensions in Facts

2 posters

Go down

Outrigger dimensions in Facts Empty Outrigger dimensions in Facts

Post  joegenshlea Wed Feb 27, 2013 5:43 pm

I don't know if the topic title properly describes my question, but here it goes.

Suppose I have a Customer dimension that reasonably large, say 50 Million rows. Suppose i have several fact tables that are much smaller in row count, usually several hundred thousand rows.

We rarely produce reports that actually report customer-level data, it is almost all group ups of demographic and geographic attributes. Ie. Customer State, Income Range, Education level, etc.

is there a reason why we would not include these customer demographics keys directly in the fact tables? Performance isn't much of an issue, this is more for user convenience, someone is asking for it, and I don't have a good reason not to do it right now.

Thoughts?

Joe

joegenshlea

Posts : 4
Join date : 2012-11-13

Back to top Go down

Outrigger dimensions in Facts Empty Re: Outrigger dimensions in Facts

Post  BoxesAndLines Thu Feb 28, 2013 6:56 pm

Demographics change. Updating one dimension row makes more sense than update 1000's of fact rows.
BoxesAndLines
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

Back to top Go down

Back to top

- Similar topics

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