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 20028

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 21360

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

3 8115

How would you delete duplicate observations?

9 20990

How would you delete observations with duplicate keys?

6 12412

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

5 12101

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 9905

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

9 17862

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

10 25594

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

5 10895

Name statements that are recognized at compile time only?

6 20569

Identify statements whose placement in the DATA step is critical?

11 25499

Name statements that function at both compile and execution time?

1 7222

Name statements that are execution only?

7 19208

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

9 14578

Un-Answered Questions { Data Warehouse }

what actually happens when bulk load mode starts?

What is a three-tier data warehouse?

1159

What is the difference between nodupkey and nodup options?

1092

What are types of batch available in cognos?

1025

What is domain and gateway node?

1211

What do you mean by drill through report?

1019

Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

2455

Where is teradata rdbms used?

1145

How to deploy from one server to another server?

2551

What are the steps to create a repository in ab initio?

1311

Can we create two repositories on same database instance in oracle?

1150

Explain confirmed dimensions. When are they used?

1029

How many universes can be created in a project?

1101

please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.

2253

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

2415

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