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

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

1040

Explain what three things do you consider to be the most important factors for a manager?

1013

What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

1013

What are the steps to do to use alerts in bo?

1399

What is the difference between condition & filter?

1468

Which versions are used in the bo dashboard work?

1058

Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

1070

What is the difference between slice and dice and cross tab report?

1064

Explain how many universes can be created in a project?

1067

How to schedule the report in b.o?

1045

Explain is there any default username & pwd for bo designer & supervisor?

1013

Explain what would you consider as your biggest achievement and why?

984

Explain about alerts in bos, under what situation we need to use alerts?

1057

What is thumbnail?

976

What is the difference between user and versatile user?

1077

Un-Answered Questions { Data Warehouse }

how u will design the report if the objects are available

2768

What is level based metrics.how will you create it?

882

What is data validation strategies for data mart v?

1095

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5126

Describe 5 ways to do a “table lookup” in SAS?

1154

What is afc?

983

What are the components of workflow manager?

1105

What are the different Lookup methods used in Informatica?

920

Explain the use of proc print and proc contents?

967

What are the different servers in sas? : sas-grid-administration

1061

What are the different kinds of views available in a datastage director?

1033

Can you explain players in datastage?

1203

What is an unconnected transformation?

1090

Can you pass sql queries in filter transformation?

1023

Explain what is a three tier data warehouse?

981

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