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

How to delete duplicate records in a flat file source?

2 8836

What is a configuration management?

1 4265

WHAT ARE THE INDEXES THAT SUPPORT DATA WAREHOUSING ? Thanks In advance Prakash

BirlaSoft,

2 6973

What is Drill by? drill through?

CMC, iFlex,

1 10830

How to test a cube?

1 2259

How to create predefined filters in B.O.

TCS,

2 11633

What is the difference between derived table and views? which one gives better performance?

TCS,

2 25068

when will use compatible and incompatible objects?

Business Intelligence Analytics, iGate, TCS,

1 8982

difference between bo 6.5 and bo xi r2

Accenture, Polaris,

3 13916

How to send duplicates to one target and unique rows to one target?target is empty

Amazon, IBM, Wipro,

9 31392

what is the difference between lookupoveride and joiner?

3 8002

what is plsql table?

2 6632

how to declare array in plsql?

1 9561

What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?

Cap Gemini, IBM,

4 18503

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2432

Un-Answered Questions { Data Warehouse }

faq's on cognos

4112

What is node? How many nodes and amps used in your previous project?

1173

Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

2168

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8283

How would you format some text using css to be verdana and bold?

1143

Hi friends, what are the new features in abinito3.0?

2858

Explain what is aggregate table and aggregate fact table ... Any examples of both?

1172

What is a rollup component? Explain about it.

1240

what are the names of the reports that you prepared?

1192

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2792

HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

2104

Demonstrate experience in maintaining quality process standards?

2669

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

1040

Explain how to generate iqd file from framework manager?

1020

hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1994

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