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

can anybody explain me in detail what is the difference between desktop intelligence and web intelligence in detail?

2 8264

how to obtain performance data for individual transformations.

2 10383

what is mapping optimization? wat are the techniques for tat

2 7732

How to handle changing source file counts in a mapping?

Deloitte, TCS,

3 19339

how to increase the perfomance in ur designer & reporting? how to reduce the refershing time & what precations would u take ?

TCS,

3 8533

i want to hide a chart in reporting level? i want to hide a prompt in designer level?

TCS,

1 7109

how to optimize the query perfomance in b.o?

TCS,

1 6724

how to solve #multivalue, #syntax, #error. iwant complete solution process in practical wise?

Accenture, TCS,

1 54355

faq's on cognos

4058

what are variable ports and list two situations when they can be used?

Satyam,

4 15917

what are the parts of Informatica server ?

GE,

1 6373

how does the server recongnise the source and target databases.Elaborate on this

Accenture,

2712

list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5 highest paid employees with in a dept,create a summery table,generate surrogate keys

2 7360

what is different between sequential batch and concurrent batch and which is recommended and why?

4941

what is the use of server?

2219

Un-Answered Questions { Data Warehouse }

Explain the difference between keylokup and joiner?

912

Explain the different kinds of facts.

999

Why cognos scenario is used?

1080

Partition, what happens if the specified key range is shorter and longer

2514

Explain and compare etl & manual development?

935

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3813

How can we Maintain the Cube Security by Category level and Dimension level ?

2372

My table got locked during mload due to a failed job. What do I do to perform other operations on it?

1123

What is cost benefit analysis (cba)?

1006

Define meta stage?

1218

Differentiate between source qualifier and filter transformation?

1590

Can we start and stop single session in concurent bstch?

958

What is meant by a Channel Driver?

1268

------------ Diff b/w MemberCaption and MemberDescription?

2331

What is rank metrics in microstrategy?

1015

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