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 the filename which you need to configure in UNIX while installing infromatica?

2 14993

If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?

1 5609

In Microstrategy, how can you direct the sql generated to use a specifc table?

Lanco,

7 22316

What is pragma?

1 5745

What are steps to be taken care to create a good Universe?

2 7837

Explain the SQL Queries activated to data base from Data provider in BO ?

Polaris,

1 4690

What is the test methodology for testing BO Universes?

Cisco, TCS,

3 10808

How to create Universe using Flat file in BO6.0

1 6716

What is the drill up , drill down, drill by , drill trough ?

TCS,

3 21505

What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

HCL,

2160

How toconnect one to one report?

iFlex,

4 9923

What are the steps to taken care to improve the Report performance?

3 9277

What is the local filter and global filter in bo's?

8 17470

Explain in Detail about Measure Objects? and what is the use of it? How to create it?

5 10397

How can we acheive Correlated sub-query in Designer?

Infosys, TCCX, Wells Fargo,

2 15949

Un-Answered Questions { Data Warehouse }

If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro

1071

How will you enable or disable caching in the system level and table level?

897

Why does microstrategy object manager search for object dependencies?

979

What are the new features of informatica 9.x at the developer level?

1049

What is the purpose of _character_ and _numeric_?

1069

What is a implicit attribute in microstrategy?

1667

How is MLOAD Teradata Server restarted after execution?

1272

define over feeding?

What is the difference between er modeling and dimensional modeling?

1154

Describe the ways in which you can create macro variables?

1202

What is the importance of the exception activity in datastage?

1073

What is event and what are the tasks related to it?

1124

Explain the difference between holap and molap?

1058

Can you define dimension?

1089

What is the use of transformation?

1002

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