General Data Warehousing Interview Questions

 
1.
What is Normalization, First Normal Form, Second Normal Form, Third Normal Form?
2.
Explain piconet?
3.
Explain What are the Different methods of loading Dimension tables?
4.
What is ODS?
5.
Explain me What are Data Marts?
6.
What is a level of Granularity of a fact table?
7.
Explain me what is VLDB?
8.
What is SCD1 , SCD2 , SCD3?
9.
Explain What is What are Semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
10.
Explain ssl?
11.
Explain What are the various Reporting tools in the Market?
12.
Explain the Difference between OLTP and OLAP?
13.
What is Snow Flake Schema?
14.
What is a lookup table?
15.
What is the Differences between star and snowflake schemas?
16.
Explain What is real time data-warehousing?
17.
What are vaious ETL tools in the Market?
18.
What is pre-emptive and non-pre-emptive?
19.
Explain What type of Indexing mechanism do we need to use for a typical datawarehouse?
20.
What are the advantages of RAID 1, 1/0, and 5. What type of RAID setup would you put your TX logs?
21.
What are modeling tools available in the Market?
22.
What is data mining?
23.
Explain What are slowly changing dimensions?
24.
What is is a Star Schema?
25.
Explain Which columns go to the fact table and which columns go the dimension table?
26.
What is a dimension table?
27.
Explain How are the Dimension tables designed?
28.
What is a general purpose scheduling tool?
29.
List down some of the real time data-warehousing tools?
30.
Explain Why should you put your data warehouse on a different system than your OLTP system?
31.
What is an ER Diagram?
32.
Explain some of modeling tools available in the Market?
33.
Explain What are non-additive facts?
34.
What is a data warehousing?
35.
What is a Fact table?
36.
Explain What does level of Granularity of a fact table signify?
37.
Explain What are conformed dimensions?
38.
Explain Why are OLTP database designs not generally a good idea for a Data Warehouse?
39.
How to load the time dimension?
40.
Explain me what are conformed dimensions?
41.
What is Normalization, First Normal Form, Second Normal Form, Third Normal Form?
42.
Explain piconet?
43.
Explain What are the Different methods of loading Dimension tables?
44.
What is ODS?
45.
Explain me What are Data Marts?
46.
What is a level of Granularity of a fact table?
47.
Explain me what is VLDB?
48.
What is SCD1 , SCD2 , SCD3?
49.
Explain What is What are Semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
50.
Explain ssl?
51.
Explain What are the various Reporting tools in the Market?
52.
Explain the Difference between OLTP and OLAP?
53.
What is Snow Flake Schema?
54.
What is a lookup table?
55.
What is the Differences between star and snowflake schemas?
56.
Explain What is real time data-warehousing?
57.
What are vaious ETL tools in the Market?
58.
What is pre-emptive and non-pre-emptive?
59.
Explain What type of Indexing mechanism do we need to use for a typical datawarehouse?
60.
What are the advantages of RAID 1, 1/0, and 5. What type of RAID setup would you put your TX logs?
61.
What are modeling tools available in the Market?
62.
What is data mining?
63.
Explain What are slowly changing dimensions?
64.
What is is a Star Schema?
65.
Explain Which columns go to the fact table and which columns go the dimension table?
66.
What is a dimension table?
67.
Explain How are the Dimension tables designed?
68.
What is a general purpose scheduling tool?
69.
List down some of the real time data-warehousing tools?
70.
Explain Why should you put your data warehouse on a different system than your OLTP system?
71.
What is an ER Diagram?
72.
Explain some of modeling tools available in the Market?
73.
Explain What are non-additive facts?
74.
What is a data warehousing?
75.
What is a Fact table?
76.
Explain What does level of Granularity of a fact table signify?
77.
Explain What are conformed dimensions?
78.
Explain Why are OLTP database designs not generally a good idea for a Data Warehouse?
79.
How to load the time dimension?
80.
Explain me what are conformed dimensions?