Datawarehouse Interview Questions and Answers
1) What is a Data Warehouse?
Answer:
2) What is the difference between an operational database and a Datawarehouse database ?
Answer:
3) What is a Datalake ?
Answer:
4) What is ETL?
Answer:
5) What are the tools available for ETL?
Answer:
6) What is OLAP (Online Analytical Processing) ?
Answer:
7) What is OLTP (Online Transactional Processing) and how it's different from OLAP?
Answer:
8) What is a Dimension table ?
Answer:
9) What is a Fact table?
Answer:
10) What are the key columns in Fact and Dimension tables ?
Answer:
11) What are Conformed dimensions and Conformed facts ?
Answer:
12) What is Dimensional Data Modelling?
Answer:
13) What is ER Data Modelling?
Answer:
14) What is a Data Mart ?
Answer:
15) What is Data Mining?
Answer:
16) What operations can be performed by an OLAP cube ?
Answer:
17) What is a sub-cube ?
Answer:
18) What is roll-up operation ?
Answer:
19) What is drill-down operation?
Answer:
20) What is slicing and dicing ?
Answer:
21) What is pivot operation ? (or) What is rotation operation?
Answer:
22) What is Normalization?
Answer:
23) What is SCD (Slowly Changing Dimensions) ?
Answer:
24) What are the types of SCD?
Answer:
25)
Related Oracle Articles:
Related Oracle Articles:
