Results 1 to 3 of 3

Thread: Examples for Star Schema & Snow flake schema

  1. #1
    Geek_Guest
    Guest

    Examples for Star Schema & Snow flake schema

    Question asked by visitor kumar

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


  2. #2
    I am the DON
    Join Date
    Apr 2006
    Answers
    99

    Exclamation Re: Examples for Star Schema & Snow flake schema

    Quote Originally Posted by Geek_Guest View Post
    Question asked by visitor kumar

    Can you provide some examples for Star Schema & Snow flake schema?
    It is better explained here for beginners...

    Hope this will help you......

    Sanghala

    If you are satisfied with my reply. Please click “Thanks” button which increases the reputation and can serve you better.

  3. #3
    Junior Member
    Join Date
    Sep 2007
    Answers
    3

    Re: Examples for Star Schema & Snow flake schema

    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


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact