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

Fact 1:N Dimension with Star Schema

2 posters

Go down

Fact 1:N Dimension with Star Schema Empty Fact 1:N Dimension with Star Schema

Post  miketgates Thu May 06, 2010 10:27 pm

This seems like a very simple problem, but I can't seem to find the answer anywhere. I want to have a situation where a single fact record is associated with 0..N dimension records of a single dimension. An example would be:
Fact Table: SalesRecord
Dimension Table: CustomGroup

In this example, a SalesRecord can be in any number of CustomGroups. This is just a fictitious example, I know it doesn't make much sense

How would a Star Schema be configured to accommodate this relationship?

miketgates

Posts : 1
Join date : 2010-05-06

Back to top Go down

Fact 1:N Dimension with Star Schema Empty Re: Fact 1:N Dimension with Star Schema

Post  BoxesAndLines Fri May 07, 2010 9:23 am

A bridge table.
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