Fact 1:N Dimension with Star Schema

View previous topic View next topic Go down

Fact 1:N Dimension with Star Schema

Post  miketgates on 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

View user profile

Back to top Go down

Re: Fact 1:N Dimension with Star Schema

Post  BoxesAndLines on Fri May 07, 2010 9:23 am

A bridge table.
avatar
BoxesAndLines

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

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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