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 53483

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

2 8121

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

9 21822

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

8 21499

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

4 15848

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

5 15649

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 6113

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

4 16643

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 16244

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

PSCI,

5 15167

Un-Answered Questions { Data Warehouse }

What is static prompt in microstrategy?

1024

Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

1946

Can you state some of the innovations throughout history?

1050

Explain what is the difference between powerplay transformer and power play reports?

1234

HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks

1974

Explain the data types present in bo n wht happens if we implement view in the designer n report?

1045

What is the different type of jobs in datastage?

1037

What are the different types of important services used in cognos?

1068

How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

1280

Can we use target hash file as a lookup ?

3384

how to export or import the jobs in .ISX file

1266

1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?

2301

Explain informatica architecture - version 8 / 9

1160

Can informatica load heterogeneous targets from heterogeneous sources?

1244

What is perform recovery?

1206

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