Make your own free website on Tripod.com
Venky's World
Schemas
Home
About Me
Favorite Links
Contact Me
Why I Started This?
Welcome to the DW World
OLTP & OLAP
How to Start Isolating data
Grain is the Grail
Schemas
Normalization
Facts & Dimensions
Oh Yeah, Its ETL Time
SCD
SCD, is this Table/Column dependent
Handling Error Loads

Schemas

 Before we get into the actual scheme of things we must get ourselves acquainted with 2 types of schemas that are generally used while building a DW.

1.                  Star Schema

2.                  Snow-flake Schema

 The explanation for these would follow later. For now understand that star schema is the most widely used & recommended schema for implementation of a DW.

Wow......Go On.......

Attitude,Not Aptitude, Determines Altitude