CoolInterview.com - World's Largest Collection of Interview Questions
Start Your Own website Now
Sponsored Links

Interview Questions
Our Services

Get 9,000 Interview Questions & Answers in an eBook.


  • 9500+ Pages
  • 9000 Question & Answers
  • All Tech. Categories
  • 14 MB Content

    Get it now !!



    Send your Resume to 6000 Companies


  • INTERVIEW QUESTIONS DATA WAREHOUSING GENERAL DATAWAREHOUSING DETAILS
    Question :
    Differences between star and snowflake schemas?
    Category General Datawarehousing Interview Questions
    Rating (0.4) By 873 users
    Added on 12/5/2004
    Views 5275
    Rate it!
    Answers:

    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 Contact E.Govardhani,srm university

    Star schema:
    1)In star schema the fact table connected by one or more dimensions with primary key and foreign key relationship.
    2)in star schema a dimension table will not have any parent table.
    3)It contain less no.of joins.
    4)It is de-normalized
    Snow flake schema:
    1)In star schema the fact table connected by one or more dimensions with primary key and foreign key relationship.
    2)In snow flake a dimension table will have one or more parent tables.
    3)It is used more joins.
    4)It is normalized.



    Posted by: sudheer    

    Contact sudheer Contact sudheer

    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.
  • Name :*
    Email Id :*
    Answer :*
    Verification Code Code Image - Please contact webmaster if you have problems seeing this image code Not readable? Load New Code
    Process Verification  Enter the above shown code:*
    Inform me about updated answers to this question

       
    Related Questions
    View Answer
    How do you load the time dimension?
    View Answer
    Why are OLTP database designs not generally a good idea for a Data Warehouse?
    View Answer
    Why should you put your data warehouse on a different system than your OLTP system?
    View Answer
    Explain the advanatages of RAID 1, 1/0, and 5. What type of RAID setup would you put your TX logs.
    View Answer


    Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

    View ALL General Datawarehousing Interview Questions

    User Options
    Sponsored Links


    Copyright ©2003-2014 CoolInterview.com, All Rights Reserved.
    Privacy Policy | Terms and Conditions

    Download Yahoo Messenger | Placement Papers| FREE SMS | ASP .Net Tutorial | Web Hosting | Dedicated Servers | C Interview Questions & Answers

    Testing Articles | Testing Books | Testing Certifications | Testing FAQs | Testing Downloads | Testing Interview Questions | Testing Jobs | Testing Training Institutes


    Cache = 0 Seconds