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 43413

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

Barclays,

1 13436

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

1 4989

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

IBM,

2 9043

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

3 15364

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

Accenture,

6 50043

What is the difference between Oracle Express and Oracle Discoverer?

1 6996

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

3 13415

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

1 5668

Where can one get more info about Data Warehousing?

TCS,

3 10859

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

Target,

12 54018

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

Oracle,

3 10390

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

ABC, Oracle, Patni,

8 37659

Difference between ODS and Staging

HeadStrong, TCS,

4 40757

wht is degenerated dimension ?it's uses?

CTS, Infosys,

10 52418

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is called dimensional modelling?

1183

Explain the data type of the surrogate key?

988

What is execution plan?

1258

Explain what are the various transformation available?

1075

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

1250

What is the function of etl when used in data warehousing?

1000

What are the methodologies of data warehousing?

1037

Explain what is a cube in data warehousing concept?

1033

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

1157

What is the difference between filter and lookup transformation?

1177

Explain what is fact less fact table? Where you have used it in your project?

983

How can we acheive correlated sub-query in designer?can anyone help me in this regard?

998

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

1008

What is freehand sql?

1098

Explain differences between star and snowflake schemas?

1237

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