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 10391

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

3 16763

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 17700

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

6 53485

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

2 8122

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

9 21823

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

8 21500

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

4 15849

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

5 15650

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

5 11875

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 8790

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 6114

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

4 16644

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 16245

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

PSCI,

5 15168

Un-Answered Questions { Data Warehouse }

Explain informatica architecture?

1058

Why cognos scenario is used?

1119

if you use oracle sql*loader , how do you transform data with it during loading?

2151

How would you get two images on microstrategy login page?

1036

Which sql query platform are you using to communicate with redshift?

Explain how abinitio eme is segregated?

1575

Can you explain surrogate key?

1106

Is union transormation is active transformation?

1034

What are the functions used for character handling?

1323

What are the different kinds of panes included in cognos?

1113

What is star schema and snowflake schema?

1073

What are the reusable transformations?

1221

how to change the execute of macro

2393

Explain data step in SAS

1163

What is a compound attribute in microstrategy?

1098

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