Too many Snowflakes or Outriggers?

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.

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