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 sort of existing documents should business analysts refer to when starting on a new project?

1011

Explain about a tricky situation for which you found a very simple solution?

1021

How would you format some text using css to be verdana and bold?

1083

What is the difference between business requirement document and use case document.

1016

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1139

explain in detail about type 3?

1022

Explain about a time when you discovered a more efficient way to do a work task?

1157

Explain in detail about type 1?

1686

What is the difference between datawarehousing and businessintelligence?

1109

Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?

1274

If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

1025

Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

1053

What is the difference in creating filters in designer and business objects?

1031

Explain in detail about type 2(scd),

1108

Explain what is the difference between business requirement document and use case document.

1031

Un-Answered Questions { Data Warehouse }

What are all the different types of prompt in cognos?

1055

Explain what is type 2 version dimension?

1015

tell me few points when u become TL

2568

How will you execute direct sql in obiee?

926

What do you mean by data sorting?

1223

Under which circumstances, informatica server creates reject files?

1104

name some data transformation used in sas di? : Sas-di

975

What is DR strategy for Informatica project?

1195

How would you copy the content of one repository to another repository?

1028

--------------Diff b/w ODS and OLAP?

3211

Can more than 1 metric be applied on an analytic in business objects?

2174

What are the available primary index types?

1226

root tree will find which is server job and which is parallel job?

1976

What is authentication? How many types of authentication.

918

tell me 5 session failure in real time how can you solve that in your project?

2309

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