Hello Friends,

For people involved with Data warehousing, this is one of the MOST TYPICAL Questions they face . ie how to convert a BIG 3rd Normalized ER Diagram into a Simple Star Schema (Dimensional Model).
In order to understand the process of CONVERTING an ER Model to STAR Schema, you can download and read CHAPTER 6, Section 6.1 of this IBM Book on Star Schema Design. The link is:


http://www.redbooks.ibm.com/abstracts/sg247138.html? Open

Also, I recommend you all to please follow the simple steps to yur ER Diagrams and see if this apporach works or not.

I tried with couple of ER diagrams and this approach works Great

Great to read,
Dave