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?

960

Why facts table is useful in representing the data?

1005

What is the use of dimensional modeling in data warehousing?

986

What is the function of surrogate key in data warehousing?

1065

Why is chameleon method used in data warehouse?

1166

Why is dimensional normalization not required?

1088

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

935

What is the difference between data warehouse and operational systems?

1141

What are the stages that are required in data warehousing?

964

What are the steps involved in designing a fact table?

891

Describe the differences between a data warehouse and data mart.

1001

Describe a data warehouse.

988

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

1035

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

981

What is data cleaning? How can we do that?

1044

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?

937

What is the difference between olap and oltp?

1057

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

1027

What is the main difference between schema in rdbms and schemas in datawarehouse?

1093

In a star schema, are foreign key constraints between facts and dimensions neccessary?

977

What is data stream and data adaopter?

1090

Explain can a dimension table contains numeric values?

967

I know of using applysimple, but there are other ways too?

960

Where the data cube technology is used?

959

What is surrogate key? Where we use it?

997

Explain what are the advantages of query studio compared to report studio?

1025

What is difference between model & package?

1030

Compare cold fusion with other programming languages?

1007

Explain the main differences between star and snowflake schema?

980

Explain what are the vaious etl tools in the market?

943

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