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

How to handle multi value dimensions?

1842

What are aggregate fact tables ? why they are needed? give an example

2 9902

State any 5 of Cods guidelines of an OLAP system, brief description each?

1 6251

what is difference between Independent Data Mart Dependent Data Mart 1- 1- 2- 2- 3- 3- 4- 4-

4 22146

Is there any difference in testing database and data ware housing?

2338

Are facts same as metrics and dimensions same as measures? If not , please tell the difference?

Patni,

1 7926

What is Grain & Granularity in Data Warehouse.

TCS, TVS,

2 45157

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.

IBM,

1879

IBM, MAHINDRA, Tech Mahindra,

4 7468

Disply the dname wise maximum salary

Principal Finance,

9 9647

i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????

Wipro,

1648

Is it possible to have more than one row on the same table with the same foreign key?

2 5543

Name at least three brands of Database Management Systems

1 4063

I HAVE A FLAT FILE DO THE NULL CHEK AND PRIMARI KEY CHEK AND DATE VALIDITAION LOAD TO TARGET TABLE

Wipro,

1 5060

Tell me the Top 10 features of oracle that supports datawarehousing.

CTS, IBM,

2 7019

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

1879

Tell me what is full load & incremental or refresh load?

573

Explain what type of indexing mechanism do we need to use for a typical datawarehouse?

673

Store (and count) non-fact records?

574

What is freehand sql?

680

What is a linked cube?

593

Explain what are the various transformation available?

597

What are target types on the server?

607

Is there any default username & pwd for bo designer & supervisor?

637

In a star schema, are foreign key constraints between facts and dimensions neccessary?

602

What is recovering sessions?

601

What is the difference between drill through and masterdetail reports?

607

Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?

595

What is Analysis Services?

1708

What is dimension modeling?

591

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