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

1059

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

1018

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

1253

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

1095

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 many numbers of cubes can we create on a single model? How can we navigate between those cubes?

1066

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

2035

How does microstrategy object manager determine if two projects are related?

1053

how to generate the test data in sas without input data? : Sas-administrator

1137

Do you view contain data?

935

Explain the term 'columns' related to relational database management system?

1066

Why should you put your data warehouse on a different system than your oltp system?

976

Explain substr function?

1110

Briefly define a session task?

1132

What information is provided by .dbc file extension for connecting to the database?

1170

What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?

1070

Give some information on report bursting?

992

Explain about a time when you discovered a more efficient way to do a work task?

1137

How do y read Sequential file from job control?

15960

Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?

1094

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