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?

1102

How to sort in descending order?

1217

Explain what is the use of proc gplot?

1143

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

1170

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

1385

How to limit decimal places for variable using proc means?

1062

What do the put and input function do?

1019

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

1047

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

1121

Where do you use proc means over proc freq?

1074

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

1229

What is the work of tranwrd function?

1198

Describe crosslist option in tables statement?

1185

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

1072

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

1088

Un-Answered Questions { Data Warehouse }

How to generate sequence numbers using expression transformation?

1038

When using multiple dml statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?

1119

What are the ways to do a “table lookup” in sas?

989

What are global filter and how they differ from column filter?

896

Name the five phases that come under MultiLoad Utility.

944

What are fundamental stages of data warehousing?

1006

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1524

what are the concerns of OLTP and DSS systems?

2411

How we are using this function?

1063

Explain data flow graph with an example?

1078

What is a pdv and what are its functions?

1073

What are the common features of Redshift?

Are you involved in writing the inferential analysis plan? Tables specfications?

2188

In SAS explain which statement does not perform automatic conversions in comparisons?

1279

Define catalog in cognos and write its various types?

1136

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