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

What is Regular Dimension and Measure Dimensions and Diff b/w them ?

2 20782

How Metrics Studio is better than Report Studio?

2695

Is it possible to see the data in dataset?

iGate,

3 8354

what are the advantages of dataset compare to fileset?

iGate,

1 7888

what are the nulls on microstrategy report and how to mask them.

iGate, TCS,

1 9352

what is the difference between the .dbc and .cfg extensions and give any clear information ?

Cognizant,

4 13925

By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?

1 6537

On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?

3 7366

1.what is the functionality of "Event Server" in BOXIR2? 2.what happen if RAS server is down in BOXIR2

CTS,

3 8178

List the transformation in informatica.

TCS,

1 12389

static prompt in microstrategy.

iGate,

2 9940

where does the default group roew in a router is stored what is the default size of memory in router

1 5177

How we will show the pop message while selecting multiple input values more than 10 in Crystal reports or any other reports?

HCL,

1 5591

what are the tabs in cognos ?

2 5568

What are exact SAS Base contents..?N what r SAS Tools..?

1 5174

Un-Answered Questions { Data Warehouse }

What actually a project contains?

1160

What are the various indexes in teradata? Why are they preferred?

1058

What do you understand by the term ‘transformation’?

1100

What is the difference between power center and power mart?

1086

What are fact, dimension, and measure?

1422

According to his methodology what all you need before you build a datawarehouse

1807

What is a view as it relates to system modeling?

1041

What are mapplets? How is it different from a Reusable Transformation?

1143

ware house management system is used?

1059

Explain difference between zabo and webi?

1151

Different circumstance which drives informatica server to expel records?

1049

how u will design the report if the objects are available

2810

Do you think effective communication is necessary for data processing? What is your strength in terms of same?

1196

Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.

1869

Explain what is the difference between business requirement document and use case document.

1076

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