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 11907

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

iGate, Infotech,

2 6590

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

Infotech,

2 5538

Can Bo generates the reports from cubical data ? Explain?

IBM,

2 6825

What is the difference between the Webintelligence and desktopintelligence?

IBM,

2 7790

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

IBM,

2 6364

What is the merge dimension?

IBM,

3 8081

Can we do the slice and dice in webintellegence?

IBM,

5 26111

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 6754

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

HCL,

1 4889

What is the use of content store in cognos?

2 11564

What is the report extension in webi and deski

2 20677

Can we test the report other than manual testing?

2178

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 5800

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

Accenture,

2 11179

Un-Answered Questions { Data Warehouse }

What is the basic structure of the SAS base program?

1334

Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?

1158

What are aggregate tables and aggregate fact tables?

1040

What are the stages of datawarehousing?

1015

Explain what is type 2 version dimension?

1014

What are the different types of partition components in abinitio?

1356

What are the conditions needed to improve the performance of informatica aggregator transformation?

1100

What is informatica? Why do we need it?

1107

What are pre and post-session shell commands?

1320

what do you mean by kimball?

1003

How can you write parallel routines in datastage PX?

1019

Explain informatica architecture - version 8 / 9

1098

Differentiate between a database and data warehouse?

1147

What are shortcuts? Where it can be used? What are the advantages?

1076

What are types of transport files?

8010

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