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?

1781

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

2 9761

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

1 6022

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

4 21904

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

2271

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

Patni,

1 7787

What is Grain & Granularity in Data Warehouse.

TCS, TVS,

2 44923

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,

1816

IBM, MAHINDRA, Tech Mahindra,

4 7223

Disply the dname wise maximum salary

Principal Finance,

9 9304

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,

1585

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

2 5360

Name at least three brands of Database Management Systems

1 3978

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

Wipro,

1 4941

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

CTS, IBM,

2 6848

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Give some difference between oltp and olap.

593

Explain the main differences between star and snowflake schema?

539

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

2049

How to define a cube??

550

What are Aggregate tables?

684

how much memory space occupied real time project (roughly)?

1801

How can we schedule the graph in unix?

559

Explain can a dimension table contains numeric values?

565

Why we use repository connectivity?

542

What are the mapping paramaters and maping variables?

568

Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.

1453

Explain how to generate iqd file from framework manager?

511

Explain the difference between oltp and olap?

684

How to import vsam files from source to target. Do we need a special plugin?

509

What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?

5266

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