Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1295
  • Last Modified:

data warehouse - star schema

Hello

I'm just reading/learning about the data warehouse star schema. Lets take what seems to be the canonical example of a star schema, where you have a sales fact table and product/store/customer etc dimension tables. Here is an example from oracle

http://download.oracle.com/docs/cd/B10501_01/server.920/a96520/schemas.htm#12896

 The sales table would have fields such as quantity_sold and cost and then keys for each dimension

I'm getting a bit confused with the traditional 3NF form of this model where you would have a 1:N relationship between customers and orders and a M:M relationship between orders and products. Here is a picture of what i mean

http://download.oracle.com/docs/cd/B10501_01/server.920/a96520/schemas.htm#14651

Using the star schema, what would happen for a sale that had multiple products? Would there be one row per product sold in the central fact table and this row would 'duplicate' the key information  (i.e. each product in the same sale would have the same key for each dimension such as customer/store/date etc)

thanks
0
andieje
Asked:
andieje
1 Solution
 
APNFSSCCommented:
Using the star schema, what would happen for a sale that had multiple products? Would there be one row per product sold in the central fact table and this row would 'duplicate' the key information  (i.e. each product in the same sale would have the same key for each dimension such as customer/store/date etc)

Yes that is correct.

I tend to use a combination of 3NF and Snowflake... I just find that is most flexible.
0
 
andiejeAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now