Data Warehouse Concepts Interview Questions

 
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 about
type 1,
type 2(SCD),
type 3?
9.
Where the applications and where
ware 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?
17.
Explain What is the difference between OLAP and datawarehosue?
18.
Explain What are non-additive facts in detail?
19.
What is cubes?
20.
Explain Why Denormalization is promoted in Universe Designing?
21.
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
22.
Explain What is fact less fact table? where you have used it in your project?
23.
Explain what is aggregate table and aggregate fact table ... any examples of both?
24.
Please explain in detail about
type 1,
type 2(SCD),
type 3?
25.
Where the applications and where
ware house management system is used?
26.
What is snapshot?
27.
What is active data warehousing?
28.
What is the difference between datawarehouse and BI?
29.
Explain Is OLAP databases are called decision support system true/false?
30.
Explain What is the difference between datawarehouse and BI?
31.
What is the difference between Datawarehousing and BusinessIntelligence?
32.
What is the difference between ODS and OLTP?