what is the difference b/w star and snowflack schema in dataware house?
The difference is in dimension tables and not the fact table. Star schema contains denormalized dimension tables while snowflake schema contains normalized dimension tables, ie dimension tables are extended in snowflake schema.