| January 01, 2008 06:17:49 |
#4 |
| jaggu_mandya |
Member Since: January 2008 Total Comments: 9 |
RE: can you convert a snowflake schema in to star schema?
|
Star ----->Snow Flake also vice versa is possible
In Star Schema
When we try to access many attributes or few attributes from a single dimension table the performance of the query falls. So we denormalize this dimension table into two or sub dimensions. Now the same star schema is transformed into snow Flake schema.
similarly reverse process is also possible.
|
| |
