Too many Snowflakes or Outriggers?

View previous topic View next topic Go down

Too many Snowflakes or Outriggers?

Post  coffee_maker on 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.

coffee_maker

Posts : 2
Join date : 2013-06-11

View user profile

Back to top Go down

Re: Too many Snowflakes or Outriggers?

Post  Mike Honey on 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
avatar
Mike Honey

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

View user profile http://www.mangasolutions.com

Back to top Go down

View previous topic View next topic Back to top


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