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?

1132

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

1035

Fact table is in normalized or de-normalized form?

1026

How can we do data cleaning?

1102

What are fundamental stages of data warehousing?

1085

What are aggregate tables and aggregate fact tables?

1094

What is vldb(very large databases)?

1072

What is the difference between view materialized view and view?

1119

Explain datawarehousing?

1120

What is operational data store (ods)?

1063

Explain dimension table ?

1043

What is bi?

1180

Explain is fact table?

973

What are vaious etl tools in the market?

1051

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

I need to set predefined condition. How I do this?

1064

Is there any default username & pwd for bo designer & supervisor?

1084

Why we use repository connectivity?

1029

What is the data type of the surrogate key?

1073

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

1110

What is the main difference between star and snowflake star schema? Which one is better and why?

1080

What function should we use to display the value entered or selected by a user in response to a prompt?

1035

How to add a number to a macro variable?

1047

What are the differences between datamart vs. Reporting cube?

1159

What is data analytics in simple terms?

1264

What are templates in which way it is help full?

1052

What is surrogate key? Where we use it? Explain with examples.

1077

What are the different methods of loading dimension tables?

1042

What are fact, dimension, and measure?

1413

What is data analysis?

1003

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