Home
Kimball Group Home
Search
Register
Log inFact 1:N Dimension with Star Schema
2 posters
Page 1 of 1
Fact 1:N Dimension with Star Schema
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?
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
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics» Star Schema for MPP databases
» Mulitple Fact Tables in a Star Schema
» Reasons to use a 3NF design over a Dimensional Model design for an EDW - Discussion
» Integrating new fact table which has one to many relationship with the main fact table in existing star schema
» How to Handle Updates to Dimension Attributes (SCD 1) that have a Cardinality > 1 (Context is Data Warehouse Star Schema)
» Mulitple Fact Tables in a Star Schema
» Reasons to use a 3NF design over a Dimensional Model design for an EDW - Discussion
» Integrating new fact table which has one to many relationship with the main fact table in existing star schema
» How to Handle Updates to Dimension Attributes (SCD 1) that have a Cardinality > 1 (Context is Data Warehouse Star Schema)
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum