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 is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?

1103

What is a cube in data warehousing concept?

1075

explain about dirty dimension?

1173

What is drilling across?

994

What are the different types of segments?

991

Explain the hierarchies level data warehousing.

885

What is the difference between junk dimension and degenerated dimension?

1136

What are data modeling and data mining? Where it will be used?

989

How much data hold in one universe.

994

What are the differences between star and snowflake schema?

1106

What is the data type of the surrogate key?

1005

How can you implement many relations in star schema model?

1001

How can you import tables from a database?

1085

What are the different types of data warehousing?

957

What is the main difference between inmon and kimball philosophies of data warehousing?

1116

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain datawarehousing?

1044

What are the data marts?

975

what are the other factors of the database on which the loading performance depend?

1911

How did you plan your Data ware house project?

2306

After the complete generation of a report who will test the report and who will analyze it?

984

What is drill-through?

988

Explain if a flat file cotains 1000 records how can I get first and last records only?

931

What is the very basic difference between data warehouse and operational databases?

967

What are the advantages of raid 1, 1/0, and

980

What are the differences between star and snowflake schema?

1106

Ist the schema that a data warehouse system can implements.

941

What are fact, dimension, and measure?

1335

How to pivot data using informatica when you have variable amount of pivot rows?

904

How to calculate fact table granularity?

1020

what are the different views that are considered when building an object-oriented software system?

1031

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