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

How to findout YEAR CALCULATION? THAT MEANS YOU SHOW THIS YEAR REVENUE AND LAST YEAR REVENUE. WHEN YOU FILTER THIS YEAR VALUE THE RESULT SHOULD DISPLAY THIS YEAR RESULT AND LAST YEAR RESULT.

Kudos India,

3 7877

actually we are migrating one project to ACTUATE business intelligence solution to COGNOS REPORTNEt? why the client want to migrate from ACTUATE to COGNOS REPORTNEt? what are the special features in COGNOS REPORTNEt?

1 5649

Describe the types of SAS programming tasks that you performed like Tables? Listings? Graphics? Ad hoc reports? Other?

HP, Oracle,

4 15911

Have you been involved in editing the data or writing data queries?

BioServe, Oracle, Sasken,

1 6121

What techniques and/or PROCs do you use for tables?

Oracle,

4 11790

Do you prefer Proc Report or Proc Tabulate? Why?

Oracle,

9 31340

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

Oracle,

3969

What do you feel about hardcoding?

Oracle,

4 8957

How experienced are you with customized reporting and use of Data _Null_ features?

Oracle,

4 10834

How do you write a test plan?

Oracle,

1 8667

What is the difference between verification and validation?

Oracle,

9 19209

What was the last computer book you purchased? Why?

Oracle,

2382

What is your favorite all time computer book? Why?

Oracle,

2518

Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??

Oracle,

2619

How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?

Oracle,

2471

Un-Answered Questions { Data Warehouse }

What are the five ways to do a table lookup in sas? : sas-grid-administration

1067

What is surrogate key? Explain with examples.

1167

What is the use of stop statement?

1089

How to get the first 100 rows from the flat file into the target?

1212

tell me about your project functionality

2348

What is teradata and why it is used?

1107

What is abinitio?

1179

Difference between star and snowflake schemas?

1161

---------------Tell me about DWH Concepts?

2160

differences between service based and product based?

2021

What is a three-tier data warehouse?

1122

What is the fact table?

1078

what is snowflake schema? : Sas-di

1221

Can a record be inserted and updated in database using microstartegy?

944

Define views in teradata with syntax.

1085

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