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 6759

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

Quintiles,

3 8835

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

8 18825

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

8 14844

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 8899

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

2 10933

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

5 13568

Code the MEANS to produce output to be used later.

2 8246

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

3 9691

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

7 18568

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

2 10087

What is the pound sign used for the DATA _NULL_?

14 31598

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

3589

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

1 7102

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

Target,

3 10728

Un-Answered Questions { Data Warehouse }

webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

4408

i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????

1988

Explain what is the use of proc gplot?

1199

How do you migrate data from one environment to another?

1095

what is the procedure for scheduling conditional rendering?

2530

Distinguish between informatica & datastage. Which one would you choose and why?

1010

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2264

How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro

1049

What is the use of function Proc summary?

1286

What is partitioning? What are the types of partitioning?

1169

Can you explain model durability?

1068

Explain what are the steps to build the data warehouse?

953

define tm1 package connector?

What are the different transaction levels available in transaction control transformation?

1209

describe the interaction table in sas di? : Sas-di

1031

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