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,

868

What are the implications?

Quintiles,

1170

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,

1150

What does the RUN statement do?

Quintiles,

841

Why is SAS considered self-documenting?

Quintiles,

1 2554

What areas of SAS are you most interested in?

Quintiles,

1049

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

Quintiles,

1004

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

Quintiles,

1 1878

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 1642

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

Quintiles,

1209

What are _numeric_ and _character_ and what do they do?

Quintiles,

1 1612

How would you create multiple observations from a single observation?

Quintiles,

1 1453

For what purpose would you use the RETAIN statement?

Quintiles,

1028

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

Quintiles,

1985

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

Quintiles,

1067

Un-Answered Questions { Data Warehouse }

What are the various kinds of containers available in datastage?

553

What are Non-additive facts?

646

What are routines in datastage?

763

what are the Methods For Creating Reusable Transformations?

635

What is the difference between drill through, drill across?

566

What is pre-emptive and non-pre-emptive?

550

What is standalone command task?

691

whom do you report?

1491

what is index?how it can work in informatica

1566

What would you consider as your biggest achievement and why?

595

What is the sequence generator transformation in informatica?

599

Give the benefits of data integration suite?

486

What is the primary index in teradata?

576

what is chore commit property?

How to drill through from a powerplay cube to reportnet?

491

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