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 are the features of base sas system?

1073

What are the advantages of using sas?

1147

What is the difference between %local and %global?

1 1655

What are the ways to do a “table lookup” in sas?

1033

What are the default statistics that proc means produce?

1051

What are the uses of sas?

1278

Why and when do you use proc sql?

1252

What are the scrubbing procedures in sas?

1014

What are the statements that are executed only?

1158

What is the difference between match merge and one to one merge?

1254

What are the statements in proc sql?

1107

What is the use of the %include statement?

1174

If you were told to create many records from one record, show how you would do this using array and with proc transpose?

1499

What sas features do you use to check errors and data validation?

1225

How to limit decimal places for the variable using proc means?

1083

Un-Answered Questions { Data Warehouse }

What is a snowflake schema?

1000

What is data mart in data warehouse?

957

Define Job control?

1153

Explain why are oltp database designs not generally a good idea for a data warehouse?

1033

Explain what is fact less fact table? Where you have used it in your project?

935

Can anybody tell me what are the tuning problems?

2048

Steps to create a data model?

1142

How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

2448

Different qualification between a related rotate toward the sky and isolates look upward?

993

what is change analysis in sas di ? : Sas-di

1062

What you mean by drill across?

1024

How can you define user defied event?

1034

Target increases every day even though no new record was inserted

1589

Describe the evaluation of parameters order in ab initio?

1534

explain about balanced dimension,

987

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