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?

1104

What is a cube in data warehousing concept?

1076

explain about dirty dimension?

1177

What is drilling across?

994

What are the different types of segments?

992

Explain the hierarchies level data warehousing.

885

What is the difference between junk dimension and degenerated dimension?

1140

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

989

How much data hold in one universe.

994

What are the differences between star and snowflake schema?

1107

What is the data type of the surrogate key?

1006

How can you implement many relations in star schema model?

1002

How can you import tables from a database?

1086

What are the different types of data warehousing?

957

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

1116

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is the difference between view materialized view and view?

1074

What are universe requirements?

1051

Explain piconet?

963

Explain what are the modules in power mart?

1051

Explain the structure of cold fusion?

1043

What is batch processing?

1034

What is the difference between constraind base load ordering and target load plan?

1120

Explain what is real time data-warehousing?

1104

Store (and count) non-fact records?

935

What is a hash cluster?

984

Explain what is cost benefit analysis (cba)?

975

What is surrogate key? Where we use it explain with example?

931

Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?

1132

Can decision tree be implemented using SQL?

2128

explain about balanced dimension,

983

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