Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
PFA
I am Developed one application but i want starschema datamodel
Please any one can help (Starschema datamodel,)
Thanks in Advance..
Hi Raju,
What you can do is Left Join "ORDERS","ORDERSUMMARY" and "ORDER DETAILS" based on OrderID and all together you can left join it with "CUSTOMERS" based on CustomerID
.
Please anyone can help me.............
Hi Raju,
I would advise you to put the tables "order", "ordersumary" and "OrderDetails" in one. Also assemble the tables "Divisions" and "Custumers" and finally the tables "products" and "categories" in this way you will have a perfect star schema model.
Hi Raju,
What you can do is Left Join "ORDERS","ORDERSUMMARY" and "ORDER DETAILS" based on OrderID and all together you can left join it with "CUSTOMERS" based on CustomerID
.
Thank U very much.........both
ClaUdio and Saumya...