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 7883

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 5651

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

HP, Oracle,

4 15917

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

BioServe, Oracle, Sasken,

1 6126

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

Oracle,

4 11792

Do you prefer Proc Report or Proc Tabulate? Why?

Oracle,

9 31347

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

Oracle,

3973

What do you feel about hardcoding?

Oracle,

4 8962

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

Oracle,

4 10842

How do you write a test plan?

Oracle,

1 8671

What is the difference between verification and validation?

Oracle,

9 19225

What was the last computer book you purchased? Why?

Oracle,

2386

What is your favorite all time computer book? Why?

Oracle,

2521

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,

2620

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,

2473

Un-Answered Questions { Data Warehouse }

Differences between version 7.x and 8.x.

1905

List any five applications of data warehouse.

948

how do you want missing values handled? : Sas programming

966

i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2701

what are the deliverables?in your project?

2158

What are the possible data marts in retail sales?

1006

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1141

how can you put a "trace" in your program? : Sas programming

1073

What are loops in Datawarehousing?

1006

What is meant by incremental aggregation?

1121

What are the stages in datastage?

1094

What are the primary characteristics of the Teradata.

1167

what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming

1093

How to restrict password to a user while sending a document in .pdf format

2354

What are the different table types that are supported by teradata?

1014

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