All Forums Training
dwuser123 9 posts Joined 04/06
13 Apr 2006
How to convert an ER Model to a Star Schema? (Practical test...

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?OpenAlso, 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 GreatGreat to read,DaveDave

You must sign in to leave a comment.