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 OLAP, ROLAP, MOLAP and HOLAP?

2 43290

What is the difference between an ODS and a W/H?

Barclays,

1 13346

What Oracle tools can be used to design and build a W/H?

1 4932

When should one use an MD-database (multi-dimensional database) and not a relational one?

IBM,

2 8915

What is a star schema? Why does one design this way?

3 15206

When should you use a STAR and when a SNOW-FLAKE schema?

Accenture,

6 49857

What is the difference between Oracle Express and Oracle Discoverer?

1 6925

How can Oracle Materialized Views be used to speed up data warehouse queries?

3 13240

What Oracle features can be used to optimize my Warehouse system?

1 5594

Where can one get more info about Data Warehousing?

TCS,

3 10722

what is the difference between aggregate table and fact table ? how do you load these two tables ?

Target,

12 53598

suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?

Oracle,

3 10222

how can one connect two fact tables ? is it possible ? how?

ABC, Oracle, Patni,

8 37419

Difference between ODS and Staging

HeadStrong, TCS,

4 40568

wht is degenerated dimension ?it's uses?

CTS, Infosys,

10 52118

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Code the tables statement for a single-level (most common) frequency?

932

What are the advantages of cold fusion?

953

Explain the difference between oltp and olap?

1124

What is data validation strategies for data mart v?

1092

Give some difference between oltp and olap.

1008

Explain what are the different types of join operations?

973

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

What is a staging area? Do we need it? What is the purpose of a staging area?

998

What is the difference between filter and lookup transformation?

1109

Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?

923

List any five applications of data warehouse.

939

What are the types of partitioning?

1049

What is surrogate key? Where we use it explain with example?

931

Why fact table is in a normal form?

991

Explain when do we analyze the tables? How do we do it?

1000

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