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 8103

What is meaning of fullpath client in business objects?

Atiric Software,

1 4931

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 5903

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

TCS,

6 20674

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 19859

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

2334

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

3 8321

how to improve the performance of the report

3 6920

What are the differences between main Cognos 8.2 and 8.3 ?

IBM,

2 6065

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 7819

what do u mean by merged dimensions in Business Objects

Business Intelligence Analytics, TCS,

2 18957

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 7488

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 9421

how to link 3 fact tables

1 7978

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

3 10090

Un-Answered Questions { Data Warehouse }

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2868

Your application mode has crashed. How would you get the instance back?

960

Explain how we drill up week to month?

1104

what are the Methods For Creating Reusable Transformations?

1189

What are the settings that you use to configure the joiner transformation?

1066

What is basic teradata query language?

1124

what is the size of u r source(like file or table)?

2282

Explain input and put function?

1151

What are all the problems you faced while validating tables and reports?

3488

How to perform incremental load in datastage?

1220

How do you generate sequence number in datastage?

1107

What Proc glm does?

1096

What do you mean by mstr? What are the different types of mstr objects?

1035

What are aggregate transformation?

1045

Can you define cube?

1040

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