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,

1386

What are the implications?

Quintiles,

1720

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,

1680

What does the RUN statement do?

Quintiles,

1309

Why is SAS considered self-documenting?

Quintiles,

1 3365

What areas of SAS are you most interested in?

Quintiles,

1538

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

Quintiles,

1519

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

Quintiles,

1 2636

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 2533

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

Quintiles,

1801

What are _numeric_ and _character_ and what do they do?

Quintiles,

1 2677

How would you create multiple observations from a single observation?

Quintiles,

1 2291

For what purpose would you use the RETAIN statement?

Quintiles,

1528

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

Quintiles,

2590

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

Quintiles,

1564

Un-Answered Questions { Data Warehouse }

any difficulitis have you phase while creating bo reports and how did u solve it

3460

flat filevalidation in informatica

2158

A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?

2235

what is pmrep command?

2444

Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you

1724

How we can create indexes after completing the loan process?

1216

Pdl with an example?

1113

what is the way of writing a feeder statement when feeding one cube from another?

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

1222

What are the joins in teradata?

1020

Which are the different editions of informatica powercenter that are available?

1034

how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..

2114

Explain why fact table is in normal form?

976

What is an active transformation?

1116

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1774

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