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

1175

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

1021

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

1001

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

1101

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

1016

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

1043

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

945

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

1023

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

1020

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

973

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

1156

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

1057

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

995

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

1125

How would you invoke a macro? : sas-macro

1048

Un-Answered Questions { Data Warehouse }

Difference between data warehousing and olap?

1050

What is etl tool in hadoop?

843

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3220

Explain and compare etl & manual development?

882

What are the different types of scd's used in data warehousing?

1187

Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?

960

what are the errors faced while bursting the reports and how to solve those errors?

1960

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

1116

What is the different lookup cache(s)?

1042

1.Have u logical models in project? If s which logical model used? 2.how do u connect to production server? 3. how do u test the data in report is same as in DWH? 4. u created one report but there is no data in the attribute. But how can u extract the data from ware house? 5. u have two tables having different ids how do u merge those table in MSTR? 6. have u faced challenging situation in u r project? Give me one example?

2517

what is null hypothesis? why do you consider that?

2854

Explain access control?

960

Explain batch processing in ab initio?

1385

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

1105

Compare ETL & Manual development?

901

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