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?

1097

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?

1085

Whether dimension table can have numeric value?

1242

What are the steps involved in creating dimensional modeling process?

1062

What is the difference between agglomerative and divisive hierarchical clustering?

1246

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

1177

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

988

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

1001

What is the purpose of cluster analysis in data warehousing?

1050

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

990

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

1042

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 the differences between star and snowflake schemas?

1116

Explain what are the modules in power mart?

1095

What are the various file formats involved in reportnet?

1026

Explain what is a view as it relates to system modeling?

1041

How do you create surrogate key using ab initio?

1051

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

1206

Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?

1166

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

1111

Explain degenerate dimension table?

1103

What is the difference between static cache and dynamic cache?

1063

what is user variable in affinium campaign? and some real time examples.

4231

How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?

992

What is surrogate key? Where we use it?

1040

What is a fact, dimension, measure?

1295

What is data type of the surrogate key?

1055

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