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 19767

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 20870

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

3 7989

How would you delete duplicate observations?

9 20687

How would you delete observations with duplicate keys?

6 12204

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

5 11971

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 9818

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

9 17618

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

10 25179

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

5 10723

Name statements that are recognized at compile time only?

6 20335

Identify statements whose placement in the DATA step is critical?

11 25152

Name statements that function at both compile and execution time?

1 7167

Name statements that are execution only?

7 19031

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

9 14295

Un-Answered Questions { Data Warehouse }

What is a cube in data warehousing concept?

1096

What metadata importer can do in ab initio?

1237

What is the difference between order and group variable in proc report?

1444

Differences between business objects and web intelligence reports?

1236

Explain fallback in teradata?

1073

How long does it take to get microstrategy desktop up and running?

1029

1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE

2151

How do we load data into Redshift?

How do you register plug-ins?

974

what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw

2335

Enlist the advantages of informatica.

1075

What is a level of granularity of a fact table?

1169

How many numbers of sessions can one group in batches?

1074

What is the difference between slice and dice and cross tab report?

1078

What are the types of caches in lookup? Explain them.

981

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