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

What is normalization, first normal form, second normal form, third normal form?

975

Explain where do we use semi and non additive facts?

1022

What is cost benefit analysis (cba)?

998

Explain what is the data type of the surrogate key?

979

Explain what is the difference between olap and datawarehosue?

1096

What are modeling tools available in the market?

979

Explain what is the advantages data mining over traditional approaches?

1029

What is your spectra photometer working principles?

985

What we will do with the universe for faster process?

984

What are the various file formats involved in reportnet?

985

Explain how many ways you create ports?

1027

Explain how to get the first 100 rows from the flat file into the target?

975

Why should you put your data warehouse on a different system than your oltp system?

978

Explain what are components of reportnet?

978

Explain a relation schema and a relation?

1116

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain the importance of data warehouse?

1015

How can we run the graph? What is the procedure for that?

948

what is difference between drill & scope of analysis?

1095

How to import vsam files from source to target. Do we need a special plugin?

937

What is a source qualifier?

1113

What is surrogate key? Explain with examples.

1164

Explain what is a cube in data warehousing concept?

987

What are situations where snowflake schema is better than star schema when the opposite is true?

983

How can we run the graph?

1075

Explain vldb?

1038

How to load the time dimension?

1019

a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron

2471

What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?

951

What is the difference between Datawarehouse and OLAP?

928

Explain datawarehousing?

1059

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