StarSchema datamodel

[Nagaraju_KCS]

Hi Community,

PFA

I am Developed one application but i want starschema datamodel

Please any one can help (Starschema datamodel,)

Thanks in Advance..

[Nagaraju_KCS]

Please anyone can help me.............

[#3]

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.

[saumyashah90 · Accepted solution]

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
.

[Nagaraju_KCS]

Thank U very much.........both

ClaUdio and Saumya...