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?

1190

How to sort in descending order?

1304

Explain what is the use of proc gplot?

1251

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

1324

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

1488

How to limit decimal places for variable using proc means?

1161

What do the put and input function do?

1118

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

1136

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

1214

Where do you use proc means over proc freq?

1194

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

1307

What is the work of tranwrd function?

1303

Describe crosslist option in tables statement?

1274

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

1229

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

1236

Un-Answered Questions { Data Warehouse }

Enlist the advantages of informatica.

1102

what are the day to day activities of teradata DBA ?

5865

What do you understand by the term 'aggregate cache'?

1027

Difference between sum function and using “+” operator?

1212

What are the various methods of getting incremental records or delta records from the source systems?

999

Can you generate sequence numbers without using the sequence generator transformation?

1167

Which commands are used to import and export the datastage jobs?

1468

What are the various transformation available?

1065

What is meant by alternate drill down with ex?

1146

How a source file is populated?

1115

What is the difference between datastage and datastage tx?

1122

A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?

1356

What is Active Datawarehousing?

1064

Why is data processing considered beneficial?

1127

what is the main advantage of impromptu over cognos reportnet?

1094

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