Sales_fact:
Product_ID (FK)
Price

Dim_Product:
Product_ID
Product_Key
Description

Problem I am facing with is what to do in case when I have products which can be in multiple categories. Should I just repeat record in Dim_Product for each category?

Example:

Fact table:
Product_ID (FK): 1
Price: 10.5

Dim_Product:
Product_ID:1
Product_Key: ABC
Description: Laptop
Category_ID: 1

Product_ID:1
Product_Key: ABC
Description: Laptop
Category_ID: 2

Dim_Category:
Category_ID (FK): 1
Description: HP

Category_ID (FK): 2
Description: Toshiba


Thanks,
Ilija

This is not a data warehouse. This is a data mart.
If you want a data warehouse, follow Inmon's model, not Kimball's.

Ok, then it's a data mart, I used wrong term. Do you know answer to my question?

Depending on what you want your mart to show, the answer could be either yer or no. Once you figure out (or explain) what your mart is showing, we can probably help you.

-PatP

Examples:
- I would like to count all products in certain category:
- Display all products from certain category
- Display all products from all categories

Thank you Pat!

For a simplified "splat" type datamart schema, you could just make product one dimension and category a completely separate sales dimension. This is great for an analytical schema like you've proposed, but would make no sense in a warehouse or an OLTP schema.

-PatP

hi. you should have all the dimension id inside the fact table. then connect their keys. this is not datawarehouse architecture.