Data Warehouse Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)

SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)

Data Warehouse Interview Questions

Questions Answers Views Company eMail

What are the tools available for etl?

1032

What is the goal of optimizer?

1098

What are the different types of datawarehosuing?

1043

What are the approaches used by optimizer during execution plan?

970

What needs to be done while starting the database?

1164

What is the definition of cube in datawarehousing?

1047

What is the difference between er modeling and dimensional modeling?

1195

What is defined as partial backup?

1134

What are the stages of datawarehousing?

1057

What is called dimensional modelling?

1188

Can we take backup when the database is opened?

1101

What are the types of dimensional modeling?

1113

What are the steps to build the datawarehouse?

1090

What is execution plan?

1259

What needs to be done when the database is shutdown?

1086

Un-Answered Questions { Data Warehouse }

What is the difference between static and dynamic conditions?

1151

How to apply securities for reports in cognos connection?

2588

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1168

what is sysdba and sysdbc ? which has high priority ?

3888

What is data type of the surrogate key?

1059

What is de-partition in abinitio?

1421

Which studio is used to create reports?

1159

Explain three-tier connection?

1012

Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

1091

How to Reset Pagenumbers in one report.

2715

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5802

How to startup obiee in linux?

934

What are the different types of olap? Give an example?

1099

What are the different ways to represent the loading of dimension tables?

984

What are the various methods of getting incremental records or delta records from the source systems?

999

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