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

Suggest a good author for hyperion in data warehousing?

972

What is metadata in context of a datawarehouse and how it is important?

1049

What is metadata in context of a datawarehouse?

1060

What is data warehosuing hierarchy?

1172

Explain the data types present in bo n wht happens if we implement view in the designer n report?

981

Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?

970

Explain degenerate dimension table?

1048

Explain the data type of the surrogate key?

952

Explain a linked cube?

959

Explain what are the methodologies of data warehousing?

926

Where we use surrogate key explain with example?

1133

Explain difference between snow flake and star schema.

1050

Difference between e-r modeling and dimentional modeling?

936

Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?

1029

Explain what are the different types of data warehousing?

963

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain clustering algorithm?

2278

What are Non-additive facts?

1169

What is the limit to the number of sources and targets you can have in a mapping?

1108

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

1039

What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?

949

Explain what are the mapping paramaters and maping variables?

1071

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

1093

How are models actually derived?

2007

Explain the difference between data ware house & data mart?

958

Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.

905

What is the difference between power center and power mart?

1025

What is the difference between star and snowflake schemas?

1214

Explain what is the difference between stop and abort?

1045

in general which algorithms for used?

2027

What is the difference between junk dimension and degenerated dimension?

1141

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