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

Name statements that are execution only.

4 6916

What is the order of evaluation of the comparison operators: + - * /** ()?

Quintiles,

3 9010

What is the significance of the ‘OF’ in X=SUM (OF a1-a4, a6, a9);?

8 19185

. Which date advances a date, time or date/time value by a given interval?

8 15204

There is a field containing a date. It needs to be displayed in the format “ddmonyy” if it’s before 1975,”dd mon ccyy” if it’s after 1985, and as ‘disco years’ if its between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT.

CTS,

3 9056

Name the option to produce a frequency line items rather that a table.

2 11094

Code a PROC MEANS that shows both summed and averaged output of the data.

5 13796

Code the MEANS to produce output to be used later.

2 8392

Do you use PROC REPORT or PROC TABULATE? Which do you prefer? Explain.

3 9842

How would you combine 3 or more tables with different structures?

7 18853

Explain the message ‘MERGE HAS ONE OR MORE DATASETS WITH REPEATS OF BY VARIABLE’.

2 10255

What is the pound sign used for the DATA _NULL_?

14 32132

sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3660

WHAT IS THE DIFFERENCE BETWEEN OLAP AND DATAWAREHOUSE? WHAT IS MICROCUBE EXACTLY?

1 7236

wat is the difference between full clinet report and thin client report?wat is the difference between desktop intelligence and web intelligence?

Target,

3 10930

Un-Answered Questions { Data Warehouse }

Are you involved in writing the inferential analysis plan? Tables specifications?

4019

how many reports have u created ? explain a few.

2160

What is the difference between business requirement document and use case document.

1080

Explain about a time when you discovered a more efficient way to do a work task?

1222

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2492

sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3660

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8284

Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2311

Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

2169

draw informatica architecture 8.6 ?

3945

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1849

I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2259

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3441

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2792

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2342

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