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 do u decide whether u need to do aggregations at database level or at Informatica level?

QualTech,

1 3257

how would u estimate the size of Lookup transform data and index cache?

2137

Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1897

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

2041

how do u really know that paging to disk is happening while u are using a lookup transform?

1991

how do u set partition points in the mapping?

2603

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

2279

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

1959

what is meant by drill through?(Mascot)

1 2877

what are the different Reporting and ETL tools available in the market?

3 12115

explain the methodology of Data Warehousing?(Polaries)

2301

what are the concerns of OLTP and DSS systems?

1963

what is the difference between OLTP database and data warehousing database?

4 7531

what is data modeling?

1914

what is the difference steps for data modeling?

2146

Un-Answered Questions { Data Warehouse }

What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?

2153

How to create repository in abinitio for stand alone system(local nt)?

1237

Explain usage analysis in datastage?

1174

How can we create index after completion of load process?

1128

Global and Local shortcuts. Advantages.

2038

What are the different types of scd's used in data warehousing?

1250

Describe crosslist option in tables statement?

1227

What do you mean by the overflow errors?

1374

How to join three sources using joiner?

1122

What are the challenges you faced while making of reports?

848

What are prompted filters?

939

Explain what is the main difference between inmon and kimball philosophies of data warehousing?

987

Where we use surrogate key explain with example?

1140

How do you convert single row from source into three rows into target?

1163

how to perform back drill through in cognos 8 what is the use of it

2547

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