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 16550

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

HP,

1 12630

What services the broadcast agent offers on the server side?

TCS,

2 9993

How can you access your repository with different user profiles?

TCS,

2 9105

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

2 8309

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 11120

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 16615

what is the architecture of any Data warehousing project?

IBM,

5 20896

what is the flow?

1 8489

Un-Answered Questions { Data Warehouse }

Why might the optimizer use a table scan when an index is available?

2311

Explain teradata architecture in detail with a diagram.

1113

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2131

What is a rollup component? Explain about it.

1189

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

1044

Why is it required to maintain a parent-child relationship among the various attributes? What are the various types of relationships depending on the number of participants?

1012

Define olap designer?

1131

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

932

What are the available primary index types in teradata.

1032

What is meant by Reportstudio shortcut?

2188

How would you find out whether a sql query is using the indices you expect?

1070

What formatting can be applied to the information that is sent out by microstrategy narrowcast server?

992

Where the datastage stored his repository?

1089

What is meant by drill down?

977

Explain the difference between a data warehouse and a data mart?

1056

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