Data warehouse

Schemas in Data Warehouse

There are different types of schemas available in the data warehousing.
Star Schema: One fact table is surrounded by different dimensions is called as a star schema. In this dimensions are de-normalized. We need only one join between fact table and dimension, So it is a simplest schema.
Snow flake Schema: One fact table is Surrounded by different dimensions and dimensions will have reference with master dimensions is called as Snow flake Schema.
Galaxy Schema: Extended Star schema is called as Galaxy schema.
Powered by Blogger.