|
|
|
Forum Newbie
Group: Forum Members
Last Login: 4/13/2006 3:46:00 AM
Posts: 9,
Visits: 1
|
|
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
Dave
Dave
|
|
|
|