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 do the SAS log messages "numeric values have been converted to character" mean?

Quintiles,

1380

What are the implications?

Quintiles,

1712

How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?

Quintiles,

1674

What does the RUN statement do?

Quintiles,

1304

Why is SAS considered self-documenting?

Quintiles,

1 3358

What areas of SAS are you most interested in?

Quintiles,

1533

What versions of SAS have you used (on which platforms)?

Quintiles,

1513

What are some problems you might encounter in processing missing values? In Data steps? Arithmetic? Comparisons? Functions? Classifying data?

Quintiles,

1 2624

How would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable?

Quintiles,

1 2524

What is the different between functions and PROCs that calculate the same simple descriptive statistics?

Quintiles,

1791

What are _numeric_ and _character_ and what do they do?

Quintiles,

1 2664

How would you create multiple observations from a single observation?

Quintiles,

1 2288

For what purpose would you use the RETAIN statement?

Quintiles,

1524

What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?

Quintiles,

2585

What is the order of application for output data set options, input data set options and SAS statements?

Quintiles,

1561

Un-Answered Questions { Data Warehouse }

what are validation tools that are used in sas? : Sas-administrator

1057

can anybody mail me the FAQS for hyperion essbase amd planning

5646

Differentiate input and infile.

1102

How to convert a numeric variable to a character variable?

1209

What is model?

967

Can you define cube?

1031

how does rules tracer help us?

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2277

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2251

Write some methods to apply securities in framework manager model?

1118

What do you understand by local lookup?

1161

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7240

what is the size of u r source(like file or table)?

2272

Explain what are the various reporting tools in the market?

981

What do you mean by staging area?

972

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