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 5510

draw the architecture of bo

IBM,

3275

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 8759

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

1 6532

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 6570

How can we do the unit testing?

Logica CMG,

3 12749

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 10222

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 7338

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,

2001

what is galaxy repository?

2 16808

task is running successfully but data is not loded why?

2 7405

what is the difference between Informatica7.1 & informatica 8.1

4 9408

whats the Diffrerence between business objects and cognos?

1 5355

what r the advantages of creating the universe?

2 7322

define universe parameters?

5 10368

Un-Answered Questions { Data Warehouse }

What are data-driven sessions?

1229

What is the function of output statement in a SAS Program?

1090

What are the types of jobs we have in datastage?

1080

What are objects? Name different type of objects in microstrategy?

947

Why do we need informatica?

1007

what are the day to day activities of BO administrator ?

3038

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6198

What is the difference between ods and oltp?

1034

Have you used rollup component? Describe how.

1084

What are the benefits of data processing according to you?

1228

What is normalization, first normal form, second normal form, third normal form?

984

How do you run datastage job from the command line?

1104

Can there be sub steps of etl steps?

1041

What is domain and gateway node?

1176

can anyone explain me about retail domain project in informatica?

7956

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