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

When looking for data contained in a character string of 150 bytes, which function is the best to locate that data: scan, index, or indexc?

7 20032

If you have a data set that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variable?

16 21379

Code a PROC SORT on a data set containing State, District and County as the primary variables, along with several numeric variables?

3 8120

How would you delete duplicate observations?

9 20996

How would you delete observations with duplicate keys?

6 12418

How would you code a merge that will keep only the observations that have matches from both sets?

5 12104

How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data set to a second data set, and the non-matches of the right-most data set to a third data set?

2 9906

What is the Program Data Vector (PDV) and What are its functions?

9 17874

Does SAS ?Translate? (compile) or does it ?Interpret?? Explain.

10 25614

At compile time when a SAS data set is read, what items are created?

5 10912

Name statements that are recognized at compile time only?

6 20576

Identify statements whose placement in the DATA step is critical?

11 25515

Name statements that function at both compile and execution time?

1 7224

Name statements that are execution only?

7 19213

In the flow of DATA step processing, what is the first action in a typical DATA Step?

9 14589

Un-Answered Questions { Data Warehouse }

What is aggregate table and aggregate fact table ... Any examples of both?

1113

what are the names of the reports that you prepared?

1185

can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................

2324

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

1026

hi i want to learn microstratogy please anyone help to me which institute is best in bangalore any one having related documents ,and video link please mail to this id avanthireddykv@gmail.com

2289

explain in detail about type 3?

1078

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2250

hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

2122

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2415

does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

6056

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4788

Have you have ever worked in unix environment and why it is useful in datastage?

1210

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

4011

I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2253

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1193

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