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

Your i-sever crashed. What will you do?

1110

What is the difference between microstrategy and cognos reporting tool?

1054

What do you mean by dimensional modeling and relational modeling? Which one do you use in dw? Why?

1019

Your account is locked and your administrator has forgotten the password. What would you do?

1109

you are required to disable webusers to use only one i-server. How would you do that?

958

How would you get two images on microstrategy login page?

1026

Explain rw document?

1155

explain html document?

1074

What are prompted filters?

995

What do you mean by mstr? What are the different types of mstr objects?

1074

How are microstrategy reports performance tuned?

1038

Explain fact degradation?

1050

What do you mean by inmon?

1137

what are the different types of fact structures?

1160

If your client wanted to customize the null value, how would you do that?

1072

Un-Answered Questions { Data Warehouse }

what is the output when -1 is put in select_expr of FBE?

1448

Explain dimensional modelling?

1033

Differentiate database data and data warehouse data?

1166

Explain what is the difference between slice and dice and cross tab report?

1146

What can be the size of largest dataset in SAS?

1281

Where the applications and where ware house management system is used?

1059

Mention a few of the ETL tools that come under Teradata.

1138

Explain what are necessary tasks to install reportnet software?

977

Explain what are the advantages data mining over traditional approaches?

1211

Explain and compare pros and cons of start schemas?

1153

what is business intelligence? : Sas-bi

1114

What is Discrete and Continuous data in Data mining world?

2705

Explain the importance of surrogate key in data warehousing?

1237

Tell e how how dealt with..

2315

What does the trace option do?

1165

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