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?

1048

What is a cube in data warehousing concept?

1032

explain about dirty dimension?

1098

What is drilling across?

943

What are the different types of segments?

928

Explain the hierarchies level data warehousing.

854

What is the difference between junk dimension and degenerated dimension?

1061

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

947

How much data hold in one universe.

950

What are the differences between star and snowflake schema?

1038

What is the data type of the surrogate key?

953

How can you implement many relations in star schema model?

959

How can you import tables from a database?

1029

What are the different types of data warehousing?

907

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

1082

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain swot analysis?

1124

What is the difference between dependent data warehouse and independent data warehouse?

951

Explain why dimenstion tables are denormalized in nature?

884

Explain how to get the first 100 rows from the flat file into the target?

934

What is type 2 version dimension?

925

Explain what are the modules in power mart?

996

What are snapshots? What are materialized views & where do we use them?

1004

Explain what are the different types of join operations?

933

Explain the different types of data warehousing?

956

Explain what is the difference between power center & power mart?

951

Explain about core dimension,

941

How to get the first 100 rows from the flat file into the target?

1173

What are the steps to build the datawarehouse?

1005

Explain a linked cube?

920

Why fact table is in a normal form?

950

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