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 10209

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

3 16639

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 17482

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

6 53236

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

2 8004

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

9 21538

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

8 21207

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

4 15670

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

5 15445

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

5 11655

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 8632

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 6051

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

4 16491

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 16042

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

PSCI,

5 15019

Un-Answered Questions { Data Warehouse }

Is Redshift a row based storage or columnar based?

Where do we use ACvisitor class?

2527

what is the difference between cardinality and Nullability?

2956

From where u get the logical query of your request?

786

Syntax for case when statement?

1074

Is there any other repository domains rather than universe, security, document?

1055

What is union transformation?

975

How can repository reports be accessed without sql or other transformations?

1235

How can a transformation be made reusable?

1178

Can you explain the process of calendar?

1121

What are logical views used for in microstrategy?

974

How to export mappings to the production environment?

921

Explain what are the basic needs to join two sources in a source qualifier?

1153

Describe the ways in which you can create macro variables?

1207

what are 3 tech challenges/ common issues you face?

2351

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