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 r the universe connection types?

4 21355

why measure objects are semantically dynamic?

1 5016

what r the types of joins universe supports

3 9012

difference between web intelligence,crystal reports and desktop intelligents

4 19151

what is the difference between proc report and proc format?

CTS,

7 14360

hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me

3 7152

what r the job openings SAS for fresher graduates !

TetraSoft, Wipro,

2470

can i link two Universes having with different connection

3 8196

15. If I select the current month and year how can we display previous 11 months data?

TCS,

2 10011

16. How can we create top 10 and bottom 10 records in the same list?

TCS,

9 36513

17. How can we display tabs in the report Footer (Ex; PAGE 1 2 3 4 5...last)?

TCS,

3 9886

how did u give developed universe to ur client?

1 4668

how to make a report avilable to other users?

2 4999

which is the best way to resolve loop context r alias why?

3 9924

what is diff between webi,deski,infoview

2 15978

Un-Answered Questions { Data Warehouse }

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2730

Explain data_null_?

1067

What is the difference between server job and parallel jobs?

1171

What is a general purpose scheduling tool?

1125

Does an informatica transformation support only aggregate expressions?

1053

Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya

1959

What is data analysis?

972

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2250

what is treatment emergent events and treatment emregent adverse event

2412

In Teradata, how do we Generate Sequence?

1057

What is the difference between an operational datastage and a data warehouse?

1164

9. What was the most complex type of report you dealt with?

2228

What are the 5 phases in a multiload utility?

1051

Explain why dimenstion tables are denormalized in nature?

931

what are the considerations when picking a SAS/STAT procedure?

3387

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