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

What Proc glm does?

1 1156

What is the use of PROC gplot?

1 1220

If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?

1 1212

What is the difference between INPUT and INFILE ?

1 1397

What is Linear Regression?

1 1233

What is interleaving in SAS?

1 1183

What is SAS informats?

1 1169

What does P-value signify about the statistical data?

1 1410

List out some key concept of SAS

1 1223

Describe the ways in which you can create macro variables?

1 1269

What is the use of function Proc summary?

1 1354

Difference between sum function and using “+” operator?

1 1220

What is PDV?

1 1213

What are the new features included in the new version of SAS Programming Language?

1 1258

What is SAS? What are the functions does it performs?

1 1260

Un-Answered Questions { Data Warehouse }

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2081

hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1993

What is the purpose of Dataware Control?

1110

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

4011

can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................

2324

does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

6056

What is dimensional table?

1145

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

838

How to create the source and target database connections in server manager?

1139

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2540

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

8274

Explain about a tricky situation for which you found a very simple solution?

1070

what are the names of the reports that you prepared?

1185

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2250

EXL informatica Questions

1451

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