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

which date function advances a date, time or datetime value by a given interval? : Sas programming

1048

name several ways to achieve efficiency in your program? : Sas programming

1071

how does sas handle missing values in sort order? : Sas programming

919

what versions of sas have you used (on which platforms)? : Sas programming

1070

how could you generate test data with no input data? : Sas programming

1187

how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming

1033

how would you determine the number of missing or nonmissing values in computations? : Sas programming

1150

how does sas handle missing values in functions? : Sas programming

1213

why is sas considered self-documenting? : Sas programming

1144

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

1145

in the flow of data step processing, what is the first action in a typical data step? : Sas programming

1076

how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming

1343

do you prefer proc report or proc tabulate? Why? : Sas programming

984

what is the effect of the options statement errors=1? : Sas programming

1060

how would you create multiple observations from a single observation? : Sas programming

1005

Un-Answered Questions { Data Warehouse }

What are stage variables and constants?

1147

How can we create a dynamic column name in cognos?

956

What are all types of Batches?

1029

Name and describe few sas character functions that are used for data cleaning in brief.

1122

What are the tuning techniques you applied during your last project

2026

Why is it required to maintain a parent-child relationship among the various attributes? What are the various types of relationships depending on the number of participants?

1012

Describe data concatenation?

1082

Define update strategy?

1226

What is the scenario which compels informatica server to reject files?

1070

Under which circumstances, informatica server creates reject files?

1095

What is data mapping and data modelling?

1554

Explain static reports?

1005

Which sql query platform are you using to communicate with redshift?

what is the difference between infile and input? : Sas-administrator

1144

What are the functions used for character handling?

1259

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