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 append procedure?

1100

Define run-group processing?

1048

Differences between where and if statement?

1106

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

1166

Difference between informat and format?

1105

Explain substr function?

1122

Explain proc sort?

1131

Compare sas with other data analytics tools.

1043

Can you explain the process of calendar?

1127

What is data _null_?

1158

What is the use of divide function?

1076

Explain proc univariate?

1041

What are the functions which are used for character handling functions?

1153

What is the core of co> operating system?

1194

What is the use of the co> operating system in ab initio?

1111

Un-Answered Questions { Data Warehouse }

Explain what transformation and how many are there in informatica?

966

How many bi services node can be clustered together?

883

What is a repository manager?

1102

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1061

What are the components of the report studio?

1195

How do you update the records with or without using update strategy?

1130

What is different between the data warehouse and data mart?

1088

how to write server Routine coding?

2137

How do you specify the number of iterations and specific condition within a single do loop?

1117

Why do we use exception activity in Datastage?

1328

Explain what are the tasks that loadmanger process will do?

937

Explain what is the difference between datawarehouse and bi?

984

What do you mean by drill across?

1161

If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro

1077

please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??

2111

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