Interview Questions And Answers Forum

Ibraheem

Webmaster

From: Capital

Registered: 2012-03-16

Posts: 23,140

Website

Warehouse Concepts Interview Questions And Answers

Data Warehouse :: Data Warehouse Concepts Job Interview Questions and Answers

Data Warehousing Concepts Frequently Asked Questions in various Data Warehouse Concepts Interviews asked by the interviewer. So learn Data Warehousing Concepts with the help of this Data Warehouse Concepts Interview questions and answers guide and feel free to comment as your suggestions, questions and answers on any Data Warehouse Concepts Interview Question or answer by the comment feature available on the page.

1 ► Explain What is the difference between OLAP and datawarehosue?
2 ► Explain What are non-additive facts in detail?
3 ► What is cubes?
4 ► Explain Why Denormalization is promoted in Universe Designing?
5 ► Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
6 ► Explain What is fact less fact table? where you have used it in your project?
7 ► Explain what is aggregate table and aggregate fact table ... any examples of both?
8 ► Please explain in detail abouttype 1,type 2(SCD),type 3?
9 ► Where the applications and whereware house management system is used?
10 ► What is snapshot?
11 ► What is active data warehousing?
12 ► What is the difference between datawarehouse and BI?
13 ► Explain Is OLAP databases are called decision support system true/false?
14 ► Explain What is the difference between datawarehouse and BI?
15 ► What is the difference between Datawarehousing and BusinessIntelligence?
16 ► What is the difference between ODS and OLTP?