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

1239

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

1067

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

1042

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

1144

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

1053

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

1094

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

997

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

1085

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

1063

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

1021

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

1256

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

1097

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

1045

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

1189

How would you invoke a macro? : sas-macro

1122

Un-Answered Questions { Data Warehouse }

what is the use of surogate key in datastage

2310

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

2226

what is pmrep command?

2438

Mention what is PROC in SAS?

1059

Which is faster fastload or multiload?

1117

What is the difference between view filter and report filter?

925

two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.

2056

Notification Activity

1408

Imagine this, you are required to reset the password for all users at a time. How would you do that?

951

What are the different plug-ins stages used in your projects?

1078

Suppose we want to display zero when null values coming to report how can we do that?

928

What is the difference between dml expression and xfr expression?

1095

Explain system call error?

1010

how many modules are there in telecome domain?how to explain the architecture?

2016

What is the difference between business requirement document and use case document.

1010

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