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 7995

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 5715

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

HP, Oracle,

4 16055

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

BioServe, Oracle, Sasken,

1 6203

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

Oracle,

4 11975

Do you prefer Proc Report or Proc Tabulate? Why?

Oracle,

9 31662

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

Oracle,

4011

What do you feel about hardcoding?

Oracle,

4 9106

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

Oracle,

4 11010

How do you write a test plan?

Oracle,

1 8763

What is the difference between verification and validation?

Oracle,

9 19488

What was the last computer book you purchased? Why?

Oracle,

2426

What is your favorite all time computer book? Why?

Oracle,

2564

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,

2678

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,

2521

Un-Answered Questions { Data Warehouse }

what is hints in cognos and where we use it.

2543

What are the primary characteristics of the Teradata.

1254

Explain what is the difference between native sql and cognos sql?

1056

Can reports be executed in off-peak periods?

1053

What do you mean by data sorting?

1281

Explain what are the different types of transformation available in informatica.

1261

What is difference between user and database in teradata?

1121

What is slibref?

1341

what are the devoleper roles in real time? plz tell i am new to datastage....

2221

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

2232

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

1045

What is meta data and system catalog?

2353

How to reverse the string using SQL?

1607

How to use consolidations in microstrategy report?

1099

how many types of prompts are there? : Sas-bi

1133

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