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?

1143

How to sort in descending order?

1258

Explain what is the use of proc gplot?

1198

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

1247

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

1436

How to limit decimal places for variable using proc means?

1113

What do the put and input function do?

1062

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

1090

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

1163

Where do you use proc means over proc freq?

1120

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

1262

What is the work of tranwrd function?

1247

Describe crosslist option in tables statement?

1224

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

1136

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

1147

Un-Answered Questions { Data Warehouse }

What is partitioning? Explain different types of partitioning?

1241

How will you use the WHO Drug Dictionary for Reporting Clinical Trials?

2339

I am unable to connect sever database(oracle) from gde(db config file) local system.i set all these?

1157

What is the purpose of trailing @ and @@? How do you use them?

1040

In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha

2273

Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

1883

How to add default rules in transformer?

1223

What are the different types of data warehousing?

957

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1269

what is the difference between microstrategy and cognos?

928

What is the use of the %include statement?

1170

What is the difference between stop and abort in informatica

1097

How to stop a batch?

984

What is the function of model design accelerator?

955

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

1119

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