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

Can we take backup when the database is opened?

1096

What are the types of dimensional modeling?

1111

What are the steps to build the datawarehouse?

1086

What is execution plan?

1258

What needs to be done when the database is shutdown?

1084

Whether dimension table can have numeric value?

1242

What are the steps involved in creating dimensional modeling process?

1061

What is the difference between agglomerative and divisive hierarchical clustering?

1246

What are the key features of chameleon that separates it from other algorithms?

1176

What are the different types of schemas used in data warehousing?

987

What is the function of etl when used in data warehousing?

1000

What is the purpose of cluster analysis in data warehousing?

1050

Why is business intelligence (bi) important in data warehousing?

989

What are the different types of fact tables used in data warehousing?

1041

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

1292

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is surrogate key? Where we use it?

1040

Is union transormation is active transformation?

1021

Explain what are the various methods of getting incremental records or delta records from the source systems?

1031

Which columns go to the fact table and which columns go the dimension table?

1020

Explain the process of extracting data from source systems,storing in ods and how data modeling is done?

967

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?

1182

What are the key columns in Fact and dimension tables?

1022

explain about dirty dimension?

1240

What according to you might be the future of data warehousing?

1077

Explain differences between star and snowflake schemas?

1237

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

1037

What is data stream and data adaopter. Is it same are different? Explain?

1088

Why null values are mapped as 0 in fact tables?

1047

Explain what is the metadata extension?

1098

What is the very basic difference between data warehouse and operational databases?

1031

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