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

How can we run the graph?

1068

In a star schema, are foreign key constraints between facts and dimensions neccessary?

977

Fact table is in normalized or de-normalized form?

962

How can we do data cleaning?

1059

What are fundamental stages of data warehousing?

1046

What are aggregate tables and aggregate fact tables?

1040

What is vldb(very large databases)?

1013

What is the difference between view materialized view and view?

1074

Explain datawarehousing?

1044

What is operational data store (ods)?

1016

Explain dimension table ?

983

What is bi?

1094

Explain is fact table?

932

What are vaious etl tools in the market?

1004

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain where do we use semi and non additive facts?

1018

Is there any difference in testing database and data ware housing?

2762

What are the different types of scd's used in data warehousing?

1247

What are the approaches used by optimizer during execution plan?

909

Explain what is the difference between a primary and secondary actor in use case modeling?

1065

What are the different types of join operations?

1002

How to design file watch jobs?

972

Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?

923

Explain what are fact, dimension, and measure?

992

What is the goal of optimizer?

1049

What is data cleaning? How can we do that?

1044

Explain difference between data ware house & data mart?

990

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

2469

What are the types of dimensional modeling?

1063

Explain what is the difference between olap and datawarehosue?

1090

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