DIFFERENCE BETWEEN STAR SCHEMA AND SNOW FLAKE SCHEMA IN DWH?

Star schema Snow flake schema
It maintains demoralized data in the dimension table It maintains normalized data in the dimension table
Performance will be increased when joining fact table to dimension table whencompared with snow flake Performance will be decreases when joining fact table to dimension table  to shrunken dimension table because it require more inner joins when compared with snow flake
All dimension table should maintain ed relation ship directly with fact table Some dimension tables are not directly  maintained relationship with fact table
Less number of Joins High Number of joins
Related Posts Plugin for WordPress, Blogger...

Be the first to comment

Leave a Reply

Your email address will not be published.


*