srinivas.vadlakonda

• Oct 16th, 2006

 

Schemas are two types starflake and snowsflake schema, In starflake fact table is in normalized format and dimention table is in denormalized format

In snowsflake both fact and dimention tables are in normalized format only

if u r taking snowsflake it requires more dimention table and more foreign keys, it will reduse the query performance. It will reduce the redundency. 

ravi guturi

• Oct 17th, 2006

 

Main advantage in starschema

1)it supports drilling and drill down options

2)fewer tables

3)less database

In snowflake schema

1)degrade query peformance because more joins is there

2)savings small storage spaces