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 specify variables to be processed by the freq procedure?

1124

Give some examples where proc report’s defaults are different than proc print’s defaults?

1139

If a variable contains letters or special characters, can it be numeric data type?

1286

Explain how merging helps to combine data sets.

1119

What is the purpose of trailing @ and @@? How do you use them?

1093

Explain what is data step?

1246

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

1401

What are the differences between proc means and proc summary?

1198

What’s the difference between var b1 – b3 and var b1 — b3?

1450

Mention what is the difference between nodupkey and nodup options?

1062

What are the default statistics for means procedure?

1299

How does proc sql work?

1147

If a variable contains only numbers, can it be a character data type?

1148

What are the steps involved in creating dimensional modeling process?

1064

What is the difference between agglomerative and divisive hierarchical clustering?

1249

Un-Answered Questions { Data Warehouse }

give the options which are available after importing data using ti?

What is staging variable?

1153

What is a implicit attribute in microstrategy?

1716

What is the way to execute pl/sql script using informatica mapping?

1685

Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.

1902

Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?

1037

What is dimensional table?

1135

what is SDLC way of code development?

2097

Explain pushdown optimization $pushdownconfig parameter - informatica

1197

AGGREGATOR default datatype

1528

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8266

In my report i want display sales rep name, country ,city how to achieve this by using repeater table

2041

Explain what are the different types of transformation available in informatica.

1254

How many ways are there to do 'remove duplicate records in informatica'?

1067

Where $mpjret is used in ab-initio?

1199

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