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

1097

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

1152

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

983

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

1135

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

1238

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

1082

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

1203

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

1288

why is sas considered self-documenting? : Sas programming

1192

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

1190

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

1112

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

1405

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

1035

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

1108

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

1058

Un-Answered Questions { Data Warehouse }

You have got the requirement from a client. Explain the technical approach you will take now.

1034

what is the procedure for scheduling conditional rendering?

2585

Define enterprise data warehousing?

1259

What is fact extension?

1211

how tokens will generate?

2249

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

1088

What are the advantages of raid 1, 1/0, and

1026

How would you copy the content of one repository to another repository?

1064

What is a level of granularity of a fact table?

1225

What are the different servers in sas? : sas-grid-administration

1105

what is session partitioning?

2209

Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

2205

What is InformaticaPowerCenter?

1179

Target increases every day even though no new record was inserted

1627

How can one identify whether mapping is correct or not without connecting session?

1498

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