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

Where do you set security levels for users in reports?

HCL,

5 10680

What is content store?

HCL,

1 6383

What is content Manager?

HCL, Kekran Mekran,

3 7886

What is the complex report you faced in real time?

2183

What do you do to make a report result in showing 4 different regions in an xl sheet in individual sheets(like Region1-sheet1,Region2-Sheet2 soon)?

IBM,

5 8127

can we join 2 different queries? One has 10 columns and other has 5+ columns?

IBM,

2 7061

What is Conditional block? How do you use in a report?

IBM,

1 15648

When to use normalization transformation other than cobol source?

2 6927

what is Difference between PROC SQL JOINS and MERGE?

Accenture, Wipro,

3 26557

what is PhaseIII, ODS, TLG, Macro and Proc in SAS

4521

What is difference between sas rename and lable?

4 10100

Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....

TCS,

1955

capital of tamilnadu

Wipro,

6 9641

Hi I have Most updated Cognos dumps like COG-112(ReportAuthor),COG-122(Admin),COG-132(Meta Data Modeller). 100%score Gurantee. If anyone intrested mail me on kris.bi121@gmail.com

16 21048

How will you move reports from Dev to QA in BO

Infosys,

3 11252

Un-Answered Questions { Data Warehouse }

Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?

1036

Explain the new features of teradata?

1045

sed,awk,head

1468

2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.

2214

How to create a repository in abinitio for stand-alone system(local nt)?

1131

Differences between business objects and web intelligence reports?

1229

What is a method to debug and test your SAS program?

1381

how do u set partition points in the mapping?

2245

Mention few capabilities of sas framework.

1195

How would you configure wh authentication? Explain.

1002

How to add a number to a macro variable?

998

Explain different types of partitioning?

1045

What is the difference between dml expression and xfr expression?

1101

draw informatica architecture 8.6 ?

3877

How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?

1377

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