Jun 7, 2007 #1 sumeshabraham Programmer Joined Nov 28, 2006 Messages 6 Location IN Hi All, Can anyone tell me to which level a Star schema is normalized? Thanks, Sumesh
Jun 7, 2007 #2 MDXer Technical User Joined Oct 19, 2002 Messages 1,982 Location US A Star Schema is not normalized. A Snow Flake Schema is normalized. Paul --------------------------------------- Shoot Me! Shoot Me NOW!!! - Daffy Duck Upvote 0 Downvote
A Star Schema is not normalized. A Snow Flake Schema is normalized. Paul --------------------------------------- Shoot Me! Shoot Me NOW!!! - Daffy Duck
Jun 7, 2007 #3 johnherman MIS Joined Oct 10, 2003 Messages 2,323 Location US Dr Ralph Kimball says a Dimensional Model (star) is in about 1.5 normal form on the average. ------------------------- The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright Upvote 0 Downvote
Dr Ralph Kimball says a Dimensional Model (star) is in about 1.5 normal form on the average. ------------------------- The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright