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 20791

How Metrics Studio is better than Report Studio?

2698

Is it possible to see the data in dataset?

iGate,

3 8356

what are the advantages of dataset compare to fileset?

iGate,

1 7893

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

iGate, TCS,

1 9356

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

Cognizant,

4 13945

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 6542

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 7381

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

CTS,

3 8183

List the transformation in informatica.

TCS,

1 12397

static prompt in microstrategy.

iGate,

2 9948

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

1 5183

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

HCL,

1 5594

what are the tabs in cognos ?

2 5572

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

1 5178

Un-Answered Questions { Data Warehouse }

How to join three sources using joiner?

1208

Repository user profiles

1819

What is meant by a Clique?

1125

What is Session and Batches?

1163

how we can generate cubes in cognos?

What is type 2 version dimension?

1029

Explain what is data validation strategies for data mart validation after loading process?

1086

Is it possible to use microstrategy object manager while other users are making changes in microstrategy agent?

998

Can decision tree be implemented using SQL?

2177

What is datastage?

1137

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1153

What are the functions of a teradata dba?

1135

What are the applications primarily used by business analyst? : Sas-bi

1055

When tpump is used instead of multiload?

1150

What are your responsibilities as an etl tester?

1264

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