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 are the different models used in cluster analysis?

1009

Why facts table is useful in representing the data?

1048

What is the use of dimensional modeling in data warehousing?

1048

What is the function of surrogate key in data warehousing?

1134

Why is chameleon method used in data warehouse?

1219

Why is dimensional normalization not required?

1142

What are the different ways to represent the loading of dimension tables?

977

What is the difference between data warehouse and operational systems?

1188

What are the stages that are required in data warehousing?

1017

What are the steps involved in designing a fact table?

933

Describe the differences between a data warehouse and data mart.

1063

Describe a data warehouse.

1030

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

1080

What are situations where snowflake schema is better than star schema when the opposite is true?

1030

What is data cleaning? How can we do that?

1087

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is Active Datawarehousing?

1057

What is a source qualifier?

1156

Explain hybrid slowly changing dimension?

1062

Explain what are non-additive facts?

1072

Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....

2378

Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.

1144

What is edw?

1269

What needs to be done when the database is shutdown?

1084

can anybody mail me the FAQS for hyperion essbase amd planning

5701

Define Data Warehousing?

1198

Explain a mapping, session, worklet, workflow, mapplet?

1151

What is the difference between static cache and dynamic cache?

1061

What is called data cleaning?

1337

Explain the data type of the surrogate key?

987

Explain me what are data marts?

1106

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