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 43289

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 4925

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

IBM,

2 8912

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

3 15204

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

Accenture,

6 49853

What is the difference between Oracle Express and Oracle Discoverer?

1 6922

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

3 13237

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

1 5592

Where can one get more info about Data Warehousing?

TCS,

3 10721

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

Target,

12 53591

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

Oracle,

3 10219

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

ABC, Oracle, Patni,

8 37418

Difference between ODS and Staging

HeadStrong, TCS,

4 40564

wht is degenerated dimension ?it's uses?

CTS, Infosys,

10 52113

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What are the data types present in bo?

1128

What are the advantages and disadvantages of reporting directly against the database?

982

What is surrogate key? Where we use it?

997

How many types of facts and what are they?

1018

Explain which are the olap tools available that are supported by oracle?

1009

what are different storage options supported by oracle ?

2091

What are the key features of chameleon that separates it from other algorithms?

1117

What are the other names given to data warehousing?

1094

Explain what is analytical or analytic mean?

1017

Briefly state different between data ware house & data mart?

1049

What is perform recovery?

1104

Explain the main differences between star and snowflake schema?

980

What is the difference between ods and oltp?

1019

What is the difference between constraind base load ordering and target load plan?

1119

What is operational data store (ods)?

1017

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