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

1238

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

1041

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

996

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

1084

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

1060

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

1019

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

1254

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

1096

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

1043

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 }

How will the AWS redshift work?

Which of the end-user items leverage olap services?

891

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2121

Have you created hierarchy in obiee. If so where and how?

889

Explain vproc in teradata?

1001

can you change the location of the obiee repository?

842

How can we use mapping variables in informatica? Where do we use them?

1200

What’s the use of redshift?

What is is the guidelines to build universe with better performance? R performance tuning issues of universes?

897

What are some commonly used bteq scripts?

1009

Have you worked with/created Parameter file

1664

What is the benefit of partitioning a session?

1182

What is main advantage datawarehousing over oracle?

1004

Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

958

How can we determine what records to extract?

1081

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