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 sort on a particular object,that object is not picked up while creating the cross tab but we need to sort on the object that is not in the cross tab????

Infosys, Keane India Ltd,

2 8109

What is meaning of fullpath client in business objects?

Atiric Software,

1 4934

I have 3 dataitems in a list username,transaction type,transaction amount. In transaction type i have 3 types 'add','update','delete', i have almost 750 rows. After displaying the list report i want to know no. of add's,update's,delete's in 3 different rows

2 5915

how many facts&dimensions tables in a sales project?can any body name those dimensions and fact tables please

TCS,

6 20700

can any body explain clearly how to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible.

Mind Tree,

8 19883

what is the role of cognos comsultant?what actually it means?pls reply

2336

wat s mapping parameter and mapping variable? how do you set that in a mapping?

3 8329

how to improve the performance of the report

3 6935

What are the differences between main Cognos 8.2 and 8.3 ?

IBM,

2 6078

if we run a report it is taking so much time to display the report,what to do to increase th performance of the report

3 7824

what do u mean by merged dimensions in Business Objects

Business Intelligence Analytics, TCS,

2 18968

rows are hide in deski,what is process,i know hide the colomn it is fulldown menu,formate>table formate>pivote>hide button,but not rows plz any body give the answer?

1 7497

if there are 2 hierarchies 1 is a-b-c and another one is a- c which hierarchy b.o takes while we use drill mode

HP,

3 9432

how to link 3 fact tables

1 7981

how we transport universes from business objects 6.5 to BOXI R2?

3 10106

Un-Answered Questions { Data Warehouse }

How union transformation is used?

1018

What is the difference between datastage and informatica?

1133

What is the need for an etl tool?

1084

How to generate or load values in to the target table based on a column value using informatica etl tool.

1085

Write different kinds of objects in microstrategy?

1011

I need level 2 to 5 sas using companies in india

2398

State the working process of decimal_strip function?

2174

What are vaious etl tools in the market?

1018

Name the five phases that come under MultiLoad Utility.

1001

how does rules tracer help us?

Explain absolute filter?

1003

please please give me some banking calculations in framework manager.

2101

What is loop in data warehousing?

1167

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

8235

What errors and types of errors you faced in Cognos ReportNet?

4205

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