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?

1050

What is the use of dimensional modeling in data warehousing?

1048

What is the function of surrogate key in data warehousing?

1137

Why is chameleon method used in data warehouse?

1223

Why is dimensional normalization not required?

1144

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

979

What is the difference between data warehouse and operational systems?

1190

What are the stages that are required in data warehousing?

1020

What are the steps involved in designing a fact table?

934

Describe the differences between a data warehouse and data mart.

1065

Describe a data warehouse.

1032

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

1082

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

1036

What is data cleaning? How can we do that?

1089

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

explain about dirty dimension?

1242

Explain what are data marts?

1205

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

How to create prompts in report net?

1041

What are the tools available for etl?

1027

How to improve session performance in aggregator transformation?

1030

What is data analysis?

1007

How can you import tables from a database?

1157

Compare aggregates and data marts

2816

What is a data profile?

1026

What is the difference between metadata and data dictionary?

1222

Explain what are the tasks that loadmanger process will do?

980

Explain the different types of data warehousing?

1033

Explain what are the methodologies of data warehousing?

970

Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.

2042

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