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

Explain input and put function?

1100

How to sort in descending order?

1214

Explain what is the use of proc gplot?

1143

What is program data vector (pdv) and what are its functions?

1168

What is the difference between order and group variable in proc report?

1382

How to limit decimal places for variable using proc means?

1060

What do the put and input function do?

1019

Give some ways by which you can define the variables to produce the summary report (using proc report)?

1045

What is the difference between using drop = data set option in data statement and set statement?

1119

Where do you use proc means over proc freq?

1074

How do you use the do loop if you don’t know how many times you should execute the do loop?

1229

What is the work of tranwrd function?

1196

Describe crosslist option in tables statement?

1185

What does proc print, and proc contents are used for?

1071

What would be the value of month at the end of data step execution and how many observations would be there?

1086

Un-Answered Questions { Data Warehouse }

How do u convert the columns to rows in datastage?

1152

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

2075

Can we have multiple application.cfm file in an application?

915

What are the types of studio present in Cognos?

1001

Can informatica load heterogeneous targets from heterogeneous sources?

1131

Can you define dimension?

1040

Differentiate between sas functions and sas procedures.

1170

What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro

998

In proc transpose and data step with arrays which one you pick?

3065

Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.

1046

Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?

942

how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause

2100

what is the custome stage in datastage? how can we impliment that one? plz tell me

2328

what is epilog tab?

faq's on cognos

4014

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