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

What SAS statements would you code to read an external raw data file to a DATA step?

Accenture,

6 13086

How do you read in the variables that you need?

Accenture,

9 24869

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

Accenture,

4 16397

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?

Accenture,

3 13721

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

Accenture, IBM,

13 31255

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

Accenture,

4 16732

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

Accenture,

6 13812

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

Accenture,

10 48616

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

Accenture,

7 15397

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

Accenture,

2 10311

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?

Accenture,

7 24201

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?

Accenture,

8 21155

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

Accenture,

4 11135

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.

Accenture,

2 9772

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

Accenture,

3 8642

Un-Answered Questions { Data Warehouse }

Explain the architecture of obiee and what each components do?

866

What olap capabilities do I have within a microstrategy report services document?

936

what is chore commit property?

What are the components of the workflow manager?

1152

What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?

1193

How can we schedule the graph in unix?

1010

What is native users?

1183

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

999

Name the different sorting methods in datastage.

1069

How do dates work in SAS data?

1192

What are the different types of variables in obiee? Explain

914

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2734

What is Fullouterjoin?

1994

Define different types of attributes in microstrategy desktop?

1251

How might one distinguish in the case of mapping is right or not without associating session?

1141

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