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

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

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


Previous Topic: synchronous capture
Next Topic: Dimensional Modeling Doubts
Goto Forum:

Current Time: Thu Aug 17 14:32:40 CDT 2017

Total time taken to generate the page: 0.07017 seconds