Snow flake schema is normalized or denormalized? Explain how?

  • Interview Candidate
  • 6
  • 3647

Showing Answers 1 - 6 of 6 Answers

jayasudha.alvi

  • Nov 6th, 2007
 

Hi,

Snow flake schema is normalized, bcoz it is interlinked with other dimensions and it is having lot of complex joins, and takes huge database size  and  the performance wise very slow it will take time a lot to retrieve the data .

cheers
Jaya

  Was this answer useful?  Yes

VAMSIKRISHNACH

  • Dec 9th, 2007
 

Facts : Always normalised in both the schemas

Dimensions : Denormalised in Star

Dimensions : Dimension bcoz of which you are calling a particular star as snow-flake only is normalised but remaining dimension are denormalised

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions