Star Schema in Data Warehouse

Star schema contain a single or mutiple fact table surrounded by dimension table.The dimension table in star schema will be denormalized.Most of the datawarehouse are designed according to star schema.Accordingly star schema as following features 1. Single(Simple Star Schema) or multiple(Complex Star Schema) fact table 2. There are fewer number of dimension table hence lesser [...]

Recent Posts

• Star Schema in Data Warehouse
• grep command in unix with example
• File Compression and archival in UNIX
• Snowflake Schema in data warehouse
• ETL tools in data warehousing?

Archives

• February 2010
• January 2010
• December 2009

Categories

• Basic Concepts in Data Warehousing
• UNIX in Data Warehousing