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 remove 1st 3 records & last 3 records in informatics

4 9793

write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690

TCS,

2 5448

write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null

TCS,

1 5114

what is repeater table and repeater where to use these? can any one explain with senario greatly helpfull

IBM,

2 17035

In my report i want display sales rep name, country ,city how to achieve this by using repeater table

IBM,

1989

What is instream data in SAS?

1 5020

what is in stream data in SAS?

1 6692

what is study design in while working with SAS? what are screening variables in SAS?

MSCR,

2251

how to handle in stream data containing semicolon in it?

3 6510

which stats created by proc means that are not created by proc summary or vice versa?

GSK,

2 6425

What are types of transport files?

PRA Health Sciences, Quintiles,

2 8016

How to convert .xls file into CSV format?

Quintiles,

6 22891

How to get any kind of data in SAS? Is it possible to take data from notepad in SAS?

GSK, TNS,

7 12729

Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?

2420

If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?

TCS,

1 7283

Un-Answered Questions { Data Warehouse }

Explain about a task that really tested your analytical abilities?

1265

how to change the execute of macro

2325

What is main use of mapplet?

1145

what is difference between drill & scope of analysis?

1102

how to connect to a flatfile through ftp in informatica

14316

What are aggregate transformation?

1044

What is amazon redshift?

Explain the difference between the truncate and delete commands?

1179

What are the various types of layout supported by abinitio?

1038

What is program data vector (pdv) and what are its functions?

1261

Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro

1209

in u r data u having duplicates how to fetch the latest data in our report?

5757

What are the features of datastage flow designer?

1051

Is data warehousing different from data mining?

1104

Is multi insert ansi standard?

2217

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