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 43130

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

Barclays,

1 13272

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

1 4825

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

IBM,

2 8790

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

3 15024

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

Accenture,

6 49591

What is the difference between Oracle Express and Oracle Discoverer?

1 6833

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

3 13069

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

1 5509

Where can one get more info about Data Warehousing?

TCS,

3 10559

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

Target,

12 53095

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

Oracle,

3 10012

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

ABC, Oracle, Patni,

8 37083

Difference between ODS and Staging

HeadStrong, TCS,

4 40325

wht is degenerated dimension ?it's uses?

CTS, Infosys,

10 51733

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is conformed fact?

1043

Explain what is the difference between view filter and report filter?

922

What are session timeout and application timeout? Where we have to do this process?

980

What are target types on the server?

940

in general which algorithms for used?

1977

Explain the versions of reportnet?

931

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?

1020

Explain what is analytical or analytic mean?

961

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

923

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

1062

for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?

2065

Explain me what are data marts?

1004

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

904

Explain me what is vldb?

877

What are the stages of datawarehousing?

955

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