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 are the features of base sas system?

1120

What are the advantages of using sas?

1195

What is the difference between %local and %global?

1 1730

What are the ways to do a “table lookup” in sas?

1085

What are the default statistics that proc means produce?

1097

What are the uses of sas?

1370

Why and when do you use proc sql?

1292

What are the scrubbing procedures in sas?

1067

What are the statements that are executed only?

1218

What is the difference between match merge and one to one merge?

1334

What are the statements in proc sql?

1157

What is the use of the %include statement?

1226

If you were told to create many records from one record, show how you would do this using array and with proc transpose?

1559

What sas features do you use to check errors and data validation?

1279

How to limit decimal places for the variable using proc means?

1131

Un-Answered Questions { Data Warehouse }

What is microstrategy desktop?

1082

How to create a permanent sas data set?

1323

can we override a native sql query within informatica? Where do we do it? How do we do it?

1119

What are situations where snow flake schema is better than star schema to use and when the opposite is true?

1052

what do the pad and dim functions do? : Sas programming

1078

what is log in cognos?

1268

how to delete one row in target dataset

3170

What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.

1040

What are the guidelines to be followed while using union transformation?

1211

how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?

2811

how does sas handle missing values in a merge? : Sas programming

1107

Explain difference between onrow and onread method?

954

What is vdl (view definition language) explain?

1113

Explain what is analytical or analytic mean?

1065

which date functions advances a date time or date/time value by a given interval? : Sas programming

1018

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