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

why we use aggregation in lower level

TCS,

1 5518

draw the architecture of bo

IBM,

3282

u drag 2 sources from 2 diff dataproviders,how we take these 2 sources into 1 single report, how we give the link these 2 sources

IBM,

4 8773

what is mean by grouping of condition column in lookup transformation?

1 6537

how to explain a project to the interviewer on sales project and what r the basics to be prepared to attend a interview

IBM,

2 6581

How can we do the unit testing?

Logica CMG,

3 12756

DATA ABC; INPUT TDATE DATE9. AVG; CARDS; 18APR2008 150.00 19APR2008 167.00 20APR2008 123.00 21APR2008 145.00 ; RUN HOW CAN I FIND THE DIFFERENCE BETWEEN AVG OF 18APR2008 ANF 21APR2008?? IF ANY ONE GETS IT PLS TRY TO POST IT.

Verinon Technology Solutions,

8 10237

can any one say me exactly when and where alias and context are used in resolving a loop. If possible try to give me a scenario also.

3 7341

Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.

SingleTusk,

2006

what is galaxy repository?

2 16810

task is running successfully but data is not loded why?

2 7412

what is the difference between Informatica7.1 & informatica 8.1

4 9418

whats the Diffrerence between business objects and cognos?

1 5361

what r the advantages of creating the universe?

2 7328

define universe parameters?

5 10385

Un-Answered Questions { Data Warehouse }

How is security handled?

1013

What are prompted filters?

952

What information is shared by the application across microstrategy web nodes?

1066

why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.

1970

for report generation which one you used proc report or data_null_?

7825

What is the difference between dml expression and xfr expression?

1115

Target increases every day even though no new record was inserted

1598

Can we create universe with no cache??

2529

What is the difference between class statement and by statement in proc means?

1316

how do u implement configuration management in Informatica?

4804

what is the one statement to set the criteria of data that can be coded in any step? : Sas programming

1161

What is tracing level? How many types of transformations supported by sorted input?

986

my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...

4243

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2142

What are the challenges you faced while making of reports?

859

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