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 do you read in the variables that you need?

5 10207

Are you familiar with special input delimiters How are they used?

3 16634

If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn?t have a value?

6 17471

What is the difference between an informat and a format. Name three informats or formats.

6 53228

Name and describe three SAS functions that you have used, if any?

2 8000

How would you code the criteria to restrict the output to be produced?

9 21524

What is the purpose of the trailing and How would you use them?

8 21195

Under what circumstances would you code a SELECT construct instead of IF statements?

4 15663

What statement do you code to tell SAS that it is to write to an external file?

5 15437

What statement do you code to write the record to the file?

5 11653

If reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record?

4 8618

If you?re not wanting any SAS output from a data step, how would you code the data statement to prevent SAS from producing a set?

1 6048

What is the one statement to set the criteria of data that can be coded in any step?

4 16484

Have you ever linked SAS code, If so, describe the link and any required statements used to either process the code or the step itself?

4 16034

How would you include common or reuse code to be processed along with your statements?

PSCI,

5 15014

Un-Answered Questions { Data Warehouse }

How to create an external dataset with sas code?

1167

What is mapping debugger?

1023

Which algorithm you used for your hashfile?

1189

what are validation tools that are used in sas? : Sas-administrator

1066

Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?

993

define query subject?

what are the facilities provided by data warehouse to analytical users?

2087

How to add default rules in transformer?

1231

What is the difference between static and dynamic conditions?

1090

Can you explain the co>operating system’s processing model?

1111

How do dates work in sas?

1148

faq's on cognos

4055

What are the steps to be taken to schedule the report?

966

What is the use of datastage designer?

1159

What are the various kinds of the hash file?

1152

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