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 PROC in SAS?

1114

How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?

1164

What does PROC print, and PROC contents do?

1282

What is factor analysis?

1203

What is the maximum length of the macro variable?

1232

Describe 5 ways to do a “table lookup” in SAS?

1199

What is SAS?

1111

Which statement does not perform automatic conversions in comparisons?

1864

What are the special input delimiters used in SAS?

1251

What are the data types does SAS contain?

1181

What do you understand by the term Normal Distribution?

1045

How to create list output for cross-tabulations in proc freq?

1158

What are the features of SAS?

1092

What is the basic syntax style in SAS?

1232

What function CATX syntax does?

1268

Un-Answered Questions { Data Warehouse }

What could be a data source system?

1106

What are the databases that informatica can connect to windows?

1111

What is the use of report studio?

1085

What are the main issues while working with flat files as source and as targets ?

1228

What you mean by drill across and what is the difference between drill through, drill across?

1093

How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?

1164

How one source columns or rows to be loaded in to two different tables?

1189

What are snapshots?

1036

What are the various kinds of the hash file?

1211

What is apt_config in datastage?

1201

Explain what are the advantages and disadvantages of reporting directly against the database?

1069

what is pmrep command?

11673

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2890

what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming

1197

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2134

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