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?

1014

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

1029

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

1084

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

1020

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

1144

explain in detail about type 3?

1023

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

1164

Explain in detail about type 1?

1687

What is the difference between datawarehousing and businessintelligence?

1115

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

1280

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?

1032

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

1058

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

1035

Explain in detail about type 2(scd),

1109

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

1036

Un-Answered Questions { Data Warehouse }

Explain the advantages of partitioned primary index in a query?

1034

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1080

How do you define data block size?

1057

Explain the difference between rolap and molap?

990

What is a full backup?

976

What do you mean by parsing?

1123

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8232

Notification Activity

1421

Can you define merge?

1138

What is the maximum length of the macro variable? : sas-macro

1107

How are indexes created after completing the load process?

1659

Explain three-tier connection?

969

How can you force the optimizer to use a particular index?

1074

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1208

What is teradata? Also, list out some of the primary characteristics of teradata.

1065

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