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?

972

What is the goal of optimizer?

1049

What are the different types of datawarehosuing?

991

What are the approaches used by optimizer during execution plan?

904

What needs to be done while starting the database?

1109

What is the definition of cube in datawarehousing?

992

What is the difference between er modeling and dimensional modeling?

1148

What is defined as partial backup?

1075

What are the stages of datawarehousing?

1013

What is called dimensional modelling?

1109

Can we take backup when the database is opened?

1044

What are the types of dimensional modeling?

1063

What are the steps to build the datawarehouse?

1039

What is execution plan?

1201

What needs to be done when the database is shutdown?

1024

Un-Answered Questions { Data Warehouse }

Is there any other repository domains rather than universe, security, document?

1046

how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance

2536

What versions of SAS have you used (on which platforms)?

1514

what are the tables used in health care domain project and columns used in report?

4512

What are the steps involved in designing a fact table?

891

what specific features and functionality do you get with olap services?

962

for whom is sas data integration studio designed? : Sas-di

1003

What are the different versions of sas that you have used until now? : sas-grid-administration

1339

what are the scrubbing procedures in sas? : Sas programming

1285

While creating table my dba has fallback or no fallback in his ddl. What is that?

1185

Migration of Reports from business objects 5.1.5 to samee version in different hardware?

2333

What is the differences between star and snowflake schemas?

1064

What are the types of security?

1028

What is basic teradata query language?

1113

What is hybrid slowly changing dimension?

1035

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