OraFAQ Forum: Data Integration » Verifying Dimensional Model

Home » Developer & Programmer » Data Integration » Verifying Dimensional Model

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Verifying Dimensional Model [message #538549]

Fri, 06 January 2012 21:47

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