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,

1381

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 3359

What areas of SAS are you most interested in?

Quintiles,

1534

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

Quintiles,

1515

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 2528

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 2665

How would you create multiple observations from a single observation?

Quintiles,

1 2290

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 is primary index and secondary index?

1028

How can a transformation be made reusable?

1168

Start a batches with in a batch?

976

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

1048

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2421

can you tell me what are the dimension tables are used in project

2303

AE datasets names? how many types?

2503

What are the different problems that ?Data mining? can solve?

2831

Define Data Stage?

1092

what is sas olap server? : Sas-di

1257

How to pivot data using informatica when you have variable amount of pivot rows?

904

Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance

2122

Describe what are the different levels of administrative users in sas? : sas-grid-administration

1038

how to implement scd2 in datastage 7.5 with lookup stage

5605

What is sorter transformation?

1046

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