Posted 28-01-08 at 07:30 PM by Spoorthi Updated 28-01-08 at 07:34 PM by Spoorthi What is Star Schema?
In Star Schema model, Fact table is surrounded by dimensional tables. Fact table is usually very large, that means it contains millions to billions of records. On the other hand dimensional tables are very small. Hence they contain a few thousands to few million records. In practice, Fact table holds transactional data and dimensional table holds master data.
The dimensional tables are specific to a fact table. This means that dimensional tables are not shared... | 
Blog Categories
Uncategorized
(2)