Data Warehouse General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Data Warehouse General Interview Questions

Questions Answers Views Company eMail

Code the tables statement to produce a multi-level frequency?

1010

Who needs data warehousing?

1063

What is data mart in data warehouse?

950

What are the fundamental elements of the data warehouse?

1001

Give some difference between oltp and olap.

1008

Can you state some of the innovations throughout history?

981

What are cluster analysis in data warehousing?

1109

What according to you might be the future of data warehousing?

1027

What are various warehousing tools?

1005

What is data analytics in simple terms?

1189

What are the different types of data warehouses?

1084

What are the design methods of data warehousing?

950

Name a few sectors which use data warehousing?

927

What are the other names given to data warehousing?

1094

What are the reasons to use a chameleon method in data warehousing?

1057

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What are the types of SCD?

1195

Where the applications and where

929

Explain in detail abt measure objects? And what is the use of it? How to create it?

1012

What are data modeling and data mining?

1085

Explain me what are conformed dimensions?

1029

What are the main steps to build the data warehouse?

1119

After the complete generation of a report who will test the report and who will analyze it?

984

Explain the main differences between star and snowflake schema?

980

How to calculate fact table granularity?

1020

Explain the main difference between inmon and kimball philosophies of data warehousing?

970

Explain grouped cross tab?

2626

Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

958

Why facts table is useful in representing the data?

1005

Explain me what is vldb?

933

what are different storage options supported by oracle ?

2091

For More Un-Answered { Data Warehouse General } Questions Click Here