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 19761

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 20861

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 20680

How would you delete observations with duplicate keys?

6 12199

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

5 11966

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 9813

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

9 17603

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

10 25171

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

5 10712

Name statements that are recognized at compile time only?

6 20328

Identify statements whose placement in the DATA step is critical?

11 25135

Name statements that function at both compile and execution time?

1 7166

Name statements that are execution only?

7 19019

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 broad cast agent? : Sas-bi

1080

Explain what three things do you consider to be the most important factors for a manager?

1020

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1676

How we can scale Reshift database?

What is the difference between static cache and dynamic cache?

1004

What are the differences between sum function and using “+” operator?

1118

What is size of a transaction and an array means in a datastage?

1321

What are modeling tools available in the market?

987

What is Star Schema?

1116

which one is better performance wise joiner or look up

1105

What are the multiload utility limitations?

1072

What are the main services provided by application tier?

990

how to create user defined function (udf) in informatica

1315

What are three tier systems in etl?

1077

What is the difference between olap and oltp?

1069

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