Data warehousing Architecture
Monday, April 28, 2008
Snow flake Schema
The Snow Flake is also the simplest data warehouse schema. Because the diagram resembles a same as star schema .But only difference is dimension table is surrounded by sub-dimension table in snow flake schema
Star Schemas
The Star Shema is the one of the simplest data warehouse schema. Because the diagram resembles a star, with points radiating from a center. The center of the star consists of one or more fact tables and the points of the star are the dimension tables.
Subscribe to:
Posts (Atom)
