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 is security domain in Business Objects?

Polaris,

4 23866

Where will you find the address of repository in Business Objects?

4 11544

What is broad cast agent?

5 16549

In Business Objects 4.1 version what is the alternative name for broadcast agent?

HP,

1 12627

What services the broadcast agent offers on the server side?

TCS,

2 9992

How can you access your repository with different user profiles?

TCS,

2 9104

How many built-in objects are created in Business Objects repository?

2 8308

What are alertors in Business Objects?

5 13511

What are different types of saving options in web intelligence?

7 16065

What is batch processing in Business Objects?

2 11118

How can you first report in Business Objects by using broadcast agent?

Ness Technologies, Wipro,

3061

Can we take report on Excel in Business Objects?

Business Intelligence Analytics, Oracle,

6 14621

what is lookup ?

7 16614

what is the architecture of any Data warehousing project?

IBM,

5 20894

what is the flow?

1 8485

Un-Answered Questions { Data Warehouse }

Name the third party tools that can be used in datastage?

1075

what is the main role of FI on business

2105

Briefly explain input and put function?

1081

How do you load only null records into target?

1216

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1167

What are all the components of Report Studio?

1096

What is the difference between slice and dice and cross tab report?

1044

What is the advantage of using shortcuts?

1182

How are indexes created after completing the load process?

1644

I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?

2009

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

920

Highlight all the modes that are present under Confidence Level.

971

Explain where do we use semi and non additive facts?

1018

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

1147

How to do unit testing in informatica? How to load data in informatica ?

1120

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