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

Explain input and put function?

1142

How to sort in descending order?

1257

Explain what is the use of proc gplot?

1198

What is program data vector (pdv) and what are its functions?

1246

What is the difference between order and group variable in proc report?

1436

How to limit decimal places for variable using proc means?

1113

What do the put and input function do?

1062

Give some ways by which you can define the variables to produce the summary report (using proc report)?

1089

What is the difference between using drop = data set option in data statement and set statement?

1160

Where do you use proc means over proc freq?

1118

How do you use the do loop if you don’t know how many times you should execute the do loop?

1262

What is the work of tranwrd function?

1246

Describe crosslist option in tables statement?

1222

What does proc print, and proc contents are used for?

1134

What would be the value of month at the end of data step execution and how many observations would be there?

1147

Un-Answered Questions { Data Warehouse }

How can bottlenecks be identified?

1016

Difference between inner join and outer join?

1025

Where $mpjret is used in ab-initio?

1146

Which date function advances a date, time or datetime value by a given interval?

1148

How to limit decimal places for variable using proc means?

1113

What is percent-to-total shortcut metric in microstrategy?

977

Connecting to iserver volume using idapi classes(java classes) and after connecting to iserver I want to execute the rox on iserver and also want know the status whether that job is succesfully run or not?

1040

What is the benefit of session partitioning?

1116

What is main difference mapplets and mapping?

1193

What is a node in teradata?

997

Can you define confirmed dimension?

1082

What are the types of caches in lookup? Explain them.

969

What is the use of datastage director?

1017

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

2303

Can microstrategy desktop access operational data systems?

1070

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