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?

1159

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?

1221

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 }

What are the primary keys and foreign keys?

1142

Differences between connected and unconnected lookup?

1218

Tell me about Dnamic and Static Dashboards?

2345

How to join three sources using joiner?

1113

define drill through?

Explain why denormalization is promoted in universe designing?

960

Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.

1088

draw informatica architecture 8.6 ?

3871

What does update strategy mean, and what are the different option of it?

1089

How to reduce warnings?

934

What is dimensional modeling?

1085

what are the reports developed in sap bw project and what is the requirement for developing it?

2178

What is a router transformation?

1127

What do you understand by the term 'dynamic cube'?

1016

lookup transformation with screenshots

4004

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