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 the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?

1183

What is a cube in data warehousing concept?

1135

explain about dirty dimension?

1240

What is drilling across?

1045

What are the different types of segments?

1035

Explain the hierarchies level data warehousing.

934

What is the difference between junk dimension and degenerated dimension?

1239

What are data modeling and data mining? Where it will be used?

1029

How much data hold in one universe.

1034

What are the differences between star and snowflake schema?

1178

What is the data type of the surrogate key?

1074

How can you implement many relations in star schema model?

1050

How can you import tables from a database?

1155

What are the different types of data warehousing?

1009

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

1148

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

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

996

Explain dimensional modelling?

1031

I know of using applysimple, but there are other ways too?

995

Explain the importance of data warehouse?

1062

Explain how are the dimension tables designed?

1109

What is incremintal loading?

1189

What are fundamental stages of data warehousing?

1087

Explain what is the difference between power center & power mart?

1047

What are necessary tasks to install reportnet software?

976

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

1038

Explain what are the basic needs to join two sources in a source qualifier?

1222

What are universe requirements?

1117

What is core dimension?

1123

how much memory space occupied real time project (roughly)?

2284

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

1037

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