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 8260

how to obtain performance data for individual transformations.

2 10370

what is mapping optimization? wat are the techniques for tat

2 7729

How to handle changing source file counts in a mapping?

Deloitte, TCS,

3 19329

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

TCS,

3 8523

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

TCS,

1 7100

how to optimize the query perfomance in b.o?

TCS,

1 6717

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

Accenture, TCS,

1 54345

faq's on cognos

4056

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

Satyam,

4 15904

what are the parts of Informatica server ?

GE,

1 6366

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

Accenture,

2706

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 7341

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

4935

what is the use of server?

2209

Un-Answered Questions { Data Warehouse }

What needs to be done when the database is shutdown?

1032

How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?

3313

Explain a mapping, session, worklet, workflow, mapplet?

1118

What is lookup table in etl testing?

1194

What are the some differences between 7.x and 8.x version of datastage?

1267

What are the tuning techniques you applied during your last project

2040

To import the flat file definition into the designer where should the flat file be placed?

1068

What is a dimension?

1039

What are vldb properties in microstrategy?

1055

How to create Target definition for flat files?

1241

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2370

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2726

What is your spectra photometer working principles?

993

Can u access a repository created in previous version of Informatica?

1874

What commands are used in the case of including or excluding any specific variables in the data set?

1105

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