Star schema - all dimensions will be linked directly with a fat table.
Snow schema - dimensions maybe interlinked or may have one-to-many relationship with other tables.
Submitted by Francis C. (xxchen74 @ hotmail . com )
star schema is less normalization,query complexity is less,transaction speed is high.
snow flake is very good in normalization,query complexity is very high and the transaction speed is medium.
Posted by: E.Govardhani,srm university
Contact E.Govardhani,srm university
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
There should not be any Spelling Mistakes.
There should not be any Gramatical Errors.
Answers must not contain any bad words.
Answers should not be the repeat of same answer, already approved.
Answer should be complete in itself.