CoolInterview.com - World's Largest Collection of Interview Questions
 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 DATA WAREHOUSING BASICS DETAILS
    Question :
    What is the main differnce between schema in RDBMS and schemas in DataWarehouse....?


    Category Data Warehousing Basics Interview Questions
    Rating (0.0) By 0 users
    Added on 7/26/2006
    Views 1685
    Rate it!
    Answers:

    RDBMS Schema
    * Used for OLTP systems
    * Traditional and old schema
    * Normalized
    * Difficult to understand and navigate
    * Cannot solve extract and complex problems
    * Poorly modelled

    DWH Schema
    * Used for OLAP systems
    * New generation schema
    * De Normalized
    * Easy to understand and navigate
    * Extract and complex problems can be easily solved
    * Very good model





    If you have the better answer, then send it to us. We will display your answer after the approval.
    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 are the possible data marts in Retail sales.?

    View Answer
    1.what is incremintal loading?
    2.what is batch processing?
    3.what is crass reference table?
    4.what is aggregate fact table

    View Answer
    What is meant by metadata in context of a Datawarehouse and how it is important?

    View Answer
    What is a linked cube?

    View Answer
    What is surrogate key ? where we use it explain with example.

    View Answer
    Wht r the data types present in bo?n wht happens if we implement view in the designer n report

    View Answer
    What is data validation strategies for data mart validation after loading process

    View Answer
    What is Data warehosuing Hierarchy?

    View Answer
    What is BUS Schema?


    View Answer
    What are the methodologies of Data Warehousing.

    View Answer

    Please Note: We keep on updating better answers to this site. Subscribe to our newsletter to get notified when better answer is posted.

    Notify me when better answer is posted!
    Email:

    View ALL Data Warehousing Basics Interview Questions

    User Options
    Sponsored Links


    Copyright ©2003-2009 CoolInterview.com, All Rights Reserved.
    Privacy Policy | Terms and Conditions
    Page URL: http://www.coolinterview.com/interview/8141/default.asp?cachecommand=bypass


    Download Yahoo Messenger | Placement Papers| FREE SMS | ASP .Net Tutorial | Web Hosting | Dedicated Servers | Joke of the Day

    0.44