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 43296

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

Barclays,

1 13354

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

1 4934

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

IBM,

2 8925

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

3 15213

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

Accenture,

6 49874

What is the difference between Oracle Express and Oracle Discoverer?

1 6931

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

3 13252

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

1 5598

Where can one get more info about Data Warehousing?

TCS,

3 10728

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

Target,

12 53634

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

Oracle,

3 10229

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

ABC, Oracle, Patni,

8 37431

Difference between ODS and Staging

HeadStrong, TCS,

4 40579

wht is degenerated dimension ?it's uses?

CTS, Infosys,

10 52147

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is a functional dependency f said to be minimal?

1068

what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.

2240

Store (and count) non-fact records?

938

Explain can a dimension table contains numeric values?

971

If two relational tables are connected to sq trans, what are the possible errors it will be thrown?

964

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

986

Explain degenerate dimension table?

1053

What is surrogate key? Explain with examples.

1164

Why we use repository connectivity?

986

What is the difference between snowflake and star schema?

1053

What are the other names given to data warehousing?

1098

what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc

2504

Explain difference between view and materialized view?

967

Explain conformed fact?

975

What is freehand sql?

1054

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