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

Too many Snowflakes or Outriggers?

2 posters

Go down

Too many Snowflakes or Outriggers? Empty Too many Snowflakes or Outriggers?

Post  coffee_maker Mon Jun 17, 2013 8:55 am

Hi All,

I am facing an issue in my Star Schema design. I have classified a lot of tables of my logical model into either dimension or fact. Now, there are a lot of tables that are not facts but give more details about my primary dimension.

For ex, I have a Study Dimension that has details of Study. Now, consider the following tables:

Study Statements (1 Study - Multiple Statements)
Study Visitors (1 Study - Multiple Visitors)

There are about 10 tables that store multiple records for a Study along with date when that was stored in source system. How should i model such 1:N relationship between dimension tables?

Do i combine 4 or 5 tables together? There is no relationship between them but I dont want to add so much of content in Study dimension.


Posts : 2
Join date : 2013-06-11

Back to top Go down

Too many Snowflakes or Outriggers? Empty Re: Too many Snowflakes or Outriggers?

Post  Mike Honey Wed Jun 19, 2013 12:21 am

Hi coffee_maker,

They sound like Facts to me, with conformed dimensions of Study and Date.  Perhaps the only measures would be Counts?

Good luck!
Mike Honey
Mike Honey

Posts : 185
Join date : 2010-08-04
Location : Melbourne, Australia

Back to top Go down

Back to top

- Similar topics

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