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 is the difference between SAS functions and procedures?

1158

Explain how you can debug and test your SAS program?

1019

Mention the validation tools used in SAS?

1186

Name few SAS functions?

1101

Mention what is PROC in SAS?

1062

How many data types are there in SAS?

1083

What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?

1163

What is the function of Stop statement in a SAS Program?

1158

Explain what is SAS informats?

1099

Mention what is SAS data set?

1137

What can be the size of largest dataset in SAS?

1235

What is the function of output statement in a SAS Program?

1079

How do dates work in SAS data?

1186

In SAS explain which statement does not perform automatic conversions in comparisons?

1317

Give an example where SAS fails to convert character value to numeric value automatically?

1094

Un-Answered Questions { Data Warehouse }

how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com

4008

Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?

2053

Why do we use exception activity in Datastage?

1321

CHANGE CAPTURE

1311

What is meant by a Highest Cost Plan?

1064

What are the different types of variables in obiee? Explain

906

What is the difference between using drop = data set option in data statement and set statement?

1166

Explain the term 'row' related to relational database management system?

956

What are the various indexes in teradata?

1053

Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

1156

Explain lookup transformation in informatica

1081

Explain what is the metadata extension?

1044

Explain ibm infosphere information server and highlight its main features?

1093

How many universes can be created in a project?

1055

Can tm1 web be set up for load balancing?

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