Examples for Star Schema & Snow flake schema

[B]Question asked by visitor kumar[/b]

Can you provide some examples for Star Schema & Snow flake schema?

[QUOTE=Geek_Guest;9994][B]Question asked by visitor kumar[/b]

Can you provide some examples for Star Schema & Snow flake schema?[/QUOTE]

It is better explained [URL="http://dwforum.sanghala.com/index.php?topic=13.0"][B][COLOR="Red"]here[/COLOR][/B][/URL] for beginners...

Hope this will help you......

Star schema is one in which all the dimensions (lookup tables) are connected to fact table. [ highly denormalized]
Snow flakes schema is one in which dimensions are normalized, but still fact are connected with these normalized dimensions. Although dimensions are not that big in size so you don't get a great space benefit and you loose performance, so star schema is preferred over snow flakes.

Hope this helped.

Cheers,
Shilpa