CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions
Interview Success Kit - Get Success in Job Interviews Interview Success Kit - 30,000 Interview Que. & Ans.
Covers 30,000+ Interview Questions asked in actual MNC Interviews - all with model answers.
Get Your Dream Job Now - www.vyoms.com
Sponsored Links
Interview Questions
Our Services

INTERVIEW QUESTIONS DATA WAREHOUSING GENERAL DATAWAREHOUSING DETAILS
Question :
Differences between star and snowflake schemas?
Category General Datawarehousing Interview Questions
Rating (3.5) By 13 users
Added on 12/5/2009
Views 3871
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

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 & Answers

    User Options
    Latest 20 Questions
    List some hosting providers supporting Dotclear?
    Give the list of Plugin-specific parameters with description?
    What is DC_TPL_CACHE parameter?
    Explain parameter DC_PLUGINS_ROOT?
    Explain parameter DC_SESSION_NAME?
    Explain parameter DC_ADMIN_URL and DC_ADMIN_MAILFROM?
    Explain parameter DC_MASTER_KEY?
    Explain the parameters used for Database settings in DotClear?
    What is config.php?
    How many ways are there to install Dotclear?
    What are the prerequisites for installing Dotclear?
    What are the actions you must take before upgrading dotclear?
    Give the meaning of the term debt- equity(D:E) ratio.
    What do you mean by financial risk?
    What is business risk?
    State the differences between operating and financial leverage.
    What is combined leverage?
    What is operating leverage?
    What is financial leverage?
    Name the types of leverages.



    Fresher Jobs | Experienced Jobs | Government Jobs | Walkin Jobs | Company Profiles | Interview Questions | Placement Papers | Companies In India | Consultants In India | Colleges In India | Exams In India | Latest Results | Notifications In India | Call Centers In India | Training Institutes In India | Job Communities In India | Courses In India | Jobs by Keyskills | Jobs by Functional Areas

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

    Gate Articles | Gate Books | Gate Colleges | Gate Downloads | Gate Faqs | Gate Jobs | Gate News | Gate Sample Papers | Gate Training Institutes

    MBA Articles | MBA Books | MBA Case Studies | MBA Business Schools | MBA Current Affairs | MBA Downloads | MBA Events | MBA Notifications | MBA FAQs | MBA Jobs
    MBA Job Consultants | MBA News | MBA Results | MBA Courses | MBA Sample Papers | MBA Interview Questions | MBA Training Institutes

    GRE Articles | GRE Books | GRE Colleges | GRE Downloads | GRE Events | GRE FAQs | GRE News | GRE Training Institutes | GRE Sample Papers

    IAS Articles | IAS Books | IAS Current Affairs | IAS Downloads | IAS Events | IAS FAQs | IAS News | IAS Notifications | IAS UPSC Jobs | IAS Previous Question Papers
    IAS Results | IAS Sample Papers | IAS Interview Questions | IAS Training Institutes | IAS Toppers Interview

    SAP Articles | SAP Books | SAP Certifications | SAP Companies | SAP Study Materials | SAP Events | SAP FAQs | SAP Jobs | SAP Job Consultants
    SAP Links | SAP News | SAP Sample Papers | SAP Interview Questions | SAP Training Institutes |




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



    Cache = 0 Seconds