Home » Developer & Programmer » Warehouse Builder » Verifying Dimensional Model
Verifying Dimensional Model [message #538549] Fri, 06 January 2012 21:47 Go to next message
ramesh_samane
Messages: 63
Registered: May 2006
Member
Hello:

This is my first post in the forum. I am new to dimensional modeling and trying to design a model based on the existing OLTP system.

Attached is the ERD for a dimension model that I have developed. Can someone expert in this area take a quick look and offer me suggestions please? It won't take much time as the model is simple. I am especially worried about the inclusion of bridge table STORE_DEPARTMENT in the model and the dimension tables referencing other dimension tables. Is this normal or I am doing it wrong? I am trying to check if the model can answer some of the DSS questions but your suggestions would really help me if I am going in a wrong direction.

Thanks in advance for your help Smile

Regards,
Ramesh
  • Attachment: DIM_ERD.jpg
    (Size: 80.68KB, Downloaded 101 times)
Re: Verifying Dimensional Model [message #538553 is a reply to message #538549] Fri, 06 January 2012 23:43 Go to previous message
ramesh_samane
Messages: 63
Registered: May 2006
Member
Here are OLTP and Dimesional Model ERDs

http://www.picpanda.com/images/hfjhxg285pgfk5z4jtdj_thumb.jpg

http://www.picpanda.com/images/pkq437un72alxm34ur3_thumb.jpg
Previous Topic: synchronous capture
Next Topic: Dimensional Modeling Doubts
Goto Forum:
  


Current Time: Sat Nov 29 00:31:15 CST 2014

Total time taken to generate the page: 0.11019 seconds