TransWikia.com

Data Warehouse design schema for sales (items, shopping carts, ..)

Data Science Asked by naheliegend on August 5, 2021

I have to design some OLAP-Cubes based on an OLTP database for the sales.

At first, that sounds very basic and common but I struggle with the item <-> shopping cart thing. One cart can contain multiple items.

How do I press this into a star schema? I have the grain of an item but also the grain of a cart.

My first shot was to build a fact table named fact_sales with the grain of an item.

For that, every item got connections to dimensions like dim_products via stored foreign key. In addition every item stores a foreign key for the dimension dim_cart. So cart would be a dimension.

But now I do not know what to do with the dimension dim_payment_method. Only whole carts get paid and not single items…

Does anyone know how to deal with that or know how to build a star schema for that?

Thank you for helping me.

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP