Data Warehousing Concepts Interview Questions & Answers

Below we have listed all the Data Warehousing Concepts Interview Questions and answers. Feel free to comment on any Data Warehousing Concepts Interview Questions or answer by the comment feature available on the page. 

     What is the difference between ODS and OLTP   

    What is the difference between datawarehouse and BI?   

    explain in detail about type 1, type 2(SCD), type 3 ?   

    What is fact less fact table? where you have used it in your project?   

    what is aggregate table and aggregate fact table ... any examples of both   

    Hyperion is the one of the tool in data ware house.its an olap tool.y u cant display that tool?   

    What is the difference between Datawarehousing and BusinessIntelligence?   
   
    Is OLAP databases are called decision support system ??? true/false?   

    What do you mean by cubes?   

    What is the difference between datawarehouse and BI?   

    Why Denormalization is promoted in Universe Designing?   

    What are non-additive facts in detail?   
  
    What is active data warehousing?   

    What is snapshot?   

    What are the functions of a reporting system?   

    What is the difference between a Java servlet and a Java applet?   

    What is the difference between OLAP and datawarehosue?   

    What is RFM analysis?   

    How are surrogate keys and metadata handled in MySQL?   

    What is the coding pattern for using a JDBC driver?