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

How to hide objects or columns?

Infotech,

6 12127

What is the user Object ? What is the need of it?

iGate, Infotech,

2 6696

How to sheduling the report ? What is the need of it?

Infotech,

2 5667

Can Bo generates the reports from cubical data ? Explain?

IBM,

2 6956

What is the difference between the Webintelligence and desktopintelligence?

IBM,

2 7891

What is the strategies ? what is the need of the strategies?

IBM,

2 6486

What is the merge dimension?

IBM,

3 8251

Can we do the slice and dice in webintellegence?

IBM,

5 26363

Can any body Explain me what are the critical problems you have faced in the designer and repoting level in the real time environment?

2 6890

It is possible with out same Queries(both Reports) we can build the drilltrough between them? and how?

HCL,

1 4963

What is the use of content store in cognos?

2 11670

What is the report extension in webi and deski

2 20787

Can we test the report other than manual testing?

2230

1. Can we import the cube into FWM? If yes how & what is the necessity to import it? 2. What is the use of TABULAR OBJECTS? Repeated Question

2 5933

How to convert flat file into xml file? How to tune joiner?

Accenture,

2 11266

Un-Answered Questions { Data Warehouse }

What is model?

1037

Differentiate between sas functions and sas procedures.

1325

How many numbers of sessions can one group in batches?

1105

how you create security to reports?

1105

can we override a native sql query within informatica? How do we do it?

1197

Can you explain the co>operating system’s processing model?

1163

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2261

What does the RUN statement do?

1359

Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)

2515

What are the different functions included in the server software?

1091

1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?

2301

can you tell me what are the dimension tables are used in project

2367

Which warehouse using in your datawarehouse

2249

Can microstrategy desktop access operational data systems?

1136

What is difference between content store and content manager?

1033

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