- 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

    Question :
    Differences between star and snowflake schemas?
    Category Data Mining Interview Questions
    Rating (0.5) By 27 users
    Added on 6/15/2011
    Views 245
    Rate it!

    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.

    If you have the better answer, then send it to us. We will display your answer after the approval.
    Rules to Post Answers in

  • 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
    What is a Star Schema?
    View Answer
    What is a Decision Tree Algorithm?
    View Answer
    What are Semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
    View Answer
    What are slowly changing dimensions?
    View Answer
    What is real time data-warehousing?
    View Answer
    What Snow Flake Schema?
    View Answer
    What type of Indexing mechanism do we need to use for a typical datawarehouse?
    View Answer
    What are non-additive facts?
    View Answer
    How are the Dimension tables designed?
    View Answer
    What is a level of Granularity of a fact table?
    View Answer
    What is ETL?
    View Answer
    What is data mining?
    View Answer
    What is Dimensional Modelling? Why is it important ?
    View Answer

    Why should you put your data warehouse on a different system than your OLTP system?
    View Answer
    What is a lookup table?
    View Answer
    What is a dimension table?
    View Answer
    What is ODS?
    View Answer
    Explain how to mine an OLAP cube?
    View Answer
    Explain how to use DMX-the data mining query language?
    View Answer
    Explain how to work with the data mining algorithms included in SQL Server data mining?
    View Answer

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

    View ALL Data Mining Interview Questions

    User Options
    Sponsored Links

    Copyright ©2003-2015, 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.046875 Seconds