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

What is the difference between %put and symbolgen? : sas-macro

1301

Describe the ways in which you can create macro variables? : sas-macro

1118

Have you used macros? For what purpose you have used? : sas-macro

1092

Tell me about % include and % eval? : sas-macro

1192

Tell me more about the parameters in macro? : sas-macro

1098

How would you define the end of a macro? : sas-macro

1137

Can you execute macro within another macro? : sas-macro

1052

If you use a symput in a data step, when and where can you use the macro variable? : sas-macro

1139

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

1122

How would you identify a macro variable? : sas-macro

1066

What are the automatic variables for macro? : sas-macro

1333

What system options would you use to help debug a macro? : sas-macro

1156

How can you create a macro variable with in data step? : sas-macro

1092

What is the difference between %local and %global? : sas-macro

1243

How would you invoke a macro? : sas-macro

1191

Un-Answered Questions { Data Warehouse }

what are the special features in cognos reportnet?

1103

What is job control?

1206

How to handle multi value dimensions?

2364

What is a datastage job?

1059

What are the difference types of stages?

1291

Name any two sas spawners? : sas-grid-administration

1098

What is a joiner transformation and why it is an active one?

1168

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2374

What do you understand by term role-playing dimension?

1122

I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry

1818

Briefly define a session task?

1200

CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

2206

What is Additive function?

2085

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

1214

What is a three-tier data warehouse?

1157

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