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?

1068

What is the difference between microstrategy and cognos reporting tool?

995

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

962

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

1031

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

892

How would you get two images on microstrategy login page?

989

Explain rw document?

1099

explain html document?

1008

What are prompted filters?

931

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

1017

How are microstrategy reports performance tuned?

970

Explain fact degradation?

993

What do you mean by inmon?

1074

what are the different types of fact structures?

1102

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

994

Un-Answered Questions { Data Warehouse }

Explain md doctor?

982

What is different between the data warehouse and data mart?

1066

What is called partitioned primary index (ppi)?

1013

What is the difference between server job and parallel jobs?

1154

How would you find out whether a sql query is using the indices you expect?

1070

Define orabulk and bcp stages?

1122

List few etl bugs?

943

What is the difference between group and associare?

1048

What is enterprise data warehousing?

1047

tell me about your project functionality

2341

How to create a repository in abinitio for stand-alone system(local nt)?

1121

What is decode in static cache?

1179

If you use a symput in a data step, when and where can you use the macro variable? : sas-macro

1084

Difference between PowerPlay transformer and power play reports?

2517

What are Non-additive facts?

1169

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