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?

1194

Explain how you can debug and test your SAS program?

1058

Mention the validation tools used in SAS?

1242

Name few SAS functions?

1156

Mention what is PROC in SAS?

1121

How many data types are there in SAS?

1146

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

1213

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

1205

Explain what is SAS informats?

1141

Mention what is SAS data set?

1189

What can be the size of largest dataset in SAS?

1288

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

1129

How do dates work in SAS data?

1232

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

1379

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

1138

Un-Answered Questions { Data Warehouse }

Highlight a few of the important components of Teradata?

1089

Why sorter is an active transformation?

1259

What is meant by Reportstudio shortcut?

2231

What is difference macros and prompts?

2404

BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

2232

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

4070

what is degenerated dimension?

4104

1143

What is usage analysis in datastage?

1367

Have you used the rollup component? Describe how?

1182

what is the difference steps for data modeling?

2662

What are the different ways to implement parallel processing in informatica?

1494

What do you understand by the cognos?

1028

What is the differnce between SDTM 3.1.2 to 3.1.1 version

5128

What are some different alternative commands associated with "dsjob"?

1223

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