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 10882

What is content store?

HCL,

1 6458

What is content Manager?

HCL, Kekran Mekran,

3 8013

What is the complex report you faced in real time?

2235

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 8302

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

IBM,

2 7162

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

IBM,

1 15714

When to use normalization transformation other than cobol source?

2 7023

what is Difference between PROC SQL JOINS and MERGE?

Accenture, Wipro,

3 26734

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

4602

What is difference between sas rename and lable?

4 10263

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,

1988

capital of tamilnadu

Wipro,

6 9877

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 21511

How will you move reports from Dev to QA in BO

Infosys,

3 11367

Un-Answered Questions { Data Warehouse }

Explain why dimenstion tables are denormalized in nature?

981

How to load a Dimension ? and how to load a fact table?

1469

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

2009

which type of project we r going to snowflake schema

2027

How can we create a dynamic column name in cognos?

1008

What is the difference between a data mart and a data warehouse?

1093

How teradata makes sure that there are no duplicate rows being inserted when its a set table?

1031

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

2245

What is the difference b/w macros and prompt?

1226

Define oconv () and iconv () functions in datastage?

1471

Where the datastage stored his repository?

1143

Define views in teradata with syntax.

1131

Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?

1024

What is the architecture of abinitio?

1157

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

2074

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