New Interview Questions.com - World's Largest Collection of Interview Questions
  Home  
 
  Ask Questions  
 
  Feed Back  
 
  My Questions  
 
  Contact Us  
 
  About Us  
 


 Interview Questions  


Test-Design-interview-questions Test Design
Testing-Tools-interview-questions Testing Tools
Testing-interview-questions Testing
Web-interview-questions Web
Clarify-CRM-interview-questions Clarify CRM
Oracle-Apps-interview-questions Oracle Apps
JCL-interview-questions JCL
DB2-interview-questions DB2
VSAM-interview-questions VSAM
IDMS-interview-questions IDMS
COBOL-interview-questions COBOL
Payroll-interview-questions Payroll
Fixed-Assets-interview-questions Fixed Assets
Cashier-interview-questions Cashier
Accounts-Receivables-interview-questions Accounts Receivables
Supervisory-interview-questions Supervisory
General-Ledger-interview-questions General Ledger
Cost-Accounting-interview-questions Cost Accounting
Audit-interview-questions Audit
Accounts-Payable-interview-questions Accounts Payable
Quantitative-interview-questions Quantitative
Oracle-interview-questions Oracle
General-interview-questions General
Logical-and-Aptitude-interview-questions Logical and Aptitude
Telecommunications-interview-questions Telecommunications
8085-interview-questions 8085
Bluetooth-interview-questions Bluetooth
Hardware-interview-questions Hardware
General-interview-questions General
Siebel-interview-questions Siebel
SAP-R-3-interview-questions SAP R-3
PeopleSoft-interview-questions PeopleSoft
Oracle-interview-questions Oracle
Operating-Systems-interview-questions Operating Systems
Networking-interview-questions Networking
Languages-interview-questions Languages
J2EE-interview-questions J2EE
Microsoft-interview-questions Microsoft
Database-interview-questions Database
Data-Warehousing-interview-questions Data Warehousing

 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

    • NEW INTERVIEW QUESTIONS.COM DATA WAREHOUSING INTERVIEW QUESTIONS DATA WAREHOUSING BASICS INTERVIEW QUESTIONS DETAILS


    NewInterviewQuestions.com - Home for World's Largest Interview Questions Website.

    A D V E R T I S E M E N T



    Add to My Questions Add to My Questions | Forward Forward | Print Print


    Question Question Difference between Snow flake and Star Schema. What are situations where Snow flake Schema is better than Star Schema to use and when the opposite is true?
    Answer Answer Star schema contains the dimesion tables mapped around one or more fact tables.

    It is a denormalised model.

    No need to use complicated joins.

    Queries results fastly.

    Snowflake schema

    It is the normalised form of Star schema.

    contains indepth joins ,bcas the tbales r splitted in to many pieces.We can easily do modification directly in the tables.

    We hav to use comlicated joins ,since we hav more tables .

    There will be some delay in processing the Query .

    © NewInterviewQuestions.com


    If you have the better answer, than send it to us. We will display your answer after the approval.
    Answer Answer:*
    Name Name:*
    Email Address Email Address:*
         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:*
     


    Rate the above answer. Help us to know about the answer.
    Category Category Data Warehousing Basics Interview Questions
    Rating Rating (3.1) By 22 users
    Added Added 7/26/2006
    Views Views 153855
    Rate it Rate it!
    Free Offers Free Offers: 300 Free Magazines for you. No credit card required. No Shipping Charges. Absolutely Free for 1 Year.

    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:





     Sponsors  

    Latest 10 Answers
    When there is any situation that u should attach a new patch to ur kernel , then download the patch and install it,to make changes to kernel , go to ok prompt and type boot -r, it will update or reconfigure the kernel
    Honesty, helpful and reliable
    procedure is a set of sql statement ,are combined to gether to perform a specific task or to solve a specifi problem.it does not return value.
    leadership is power to influence a group so that the members willingly exert efforts as aspired by the leader.
    I have the unique combination of technical skill and the ability to build strong customer relationship. I have the ability to stay focussed in stressfull situation. I would be great addition to your team.
    first execute the bc search spec to fetch the data then executes the applet search spec if applet search spec is not match with bc it skips
    TCP-Transmission Control Protocol. TCP is Reliable. TCP is Connection oriented. UDP-User Datagram Protoco UDP is Unreliable. UDP is Connectionless.
    By default in structure all data member and member function are public,i,e if you not mentation any access specifier. But in case of class By default all data member and member function are private.
    Structure is a user defined data type. By default all structure variables are public type and we cann't use access specifier in structure type variable, where as in class we can define objects(variables) under required access specifier type.
    variable cost is the cost which is not fixed in nature

    Newinterviewquestions.com is a part of Vyom Network. Top



    Copyright © 2018, newinterviewquestions.com. All rights reserved Privacy Policy | Terms and Conditions

    Page URL: http://www.newinterviewquestions.com/interview/8148/Default.asp?cachecommand=bypass


    Download Yahoo Messenger | Web Hosting | Dedicated Server | Free SMS Domain Registration | Windows Hosting | Linux Hosting | Java Hosting | Virtual Dedicated Server | Dedicated Server | Reseller Web Hosting | Unlimited Windows reseller hosting | Unlimited Linux reseller hosting | Cheap Windows reseller hosting | Cheap Linux reseller hosting | Cheap Windows hosting | Best Windows hosting | Windows hosting Multiple Domains | Unlimited Windows hosting | Compare hosting plans | Cheap Linux hosting | Best Linux hosting | Linux hosting Multiple Domains | Unlimited Linux hosting | Cheap asp.net hosting | Best asp.net hosting | unlimited asp.net hosting | Cheap asp.net reseller hosting | Unlimited asp.net reseller hosting | Java Features | Cheap Java hosting | Best Java hosting | unlimited Java Hosting | Unlimited Linux reseller hosting | Java Hosting Multiple Domains Quick2host Reviews Buy Online Traffic