Data Warehouse General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Data Warehouse General Interview Questions

Questions Answers Views Company eMail

What is source qualifier?

2 10359

Difference between DSS & OLTP?

IBM,

6 51995

Explain grouped cross tab?

2666

Hierarchy of DWH?

Accenture, EDS, IBM, iFlex, TCS,

2 19267

How many repositories can we create in Informatica?

Informatica,

14 29417

What is surrogate key?

IBM, Informatica,

5 22754

What is difference between Mapplet and reusable transformation?

UST,

3 7704

What is aggregate awareness?

2 8114

Explain reference cursor?

2218

What are parallel querys and query hints?

2273

DWH architecture?

6 18893

What are cursors?

4 9394

Advantages of de normalized data?

2 11533

What is operational data source (ODS)?

2 10690

What is meta data and system catalog?

2344

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain the difference between keylokup and joiner?

932

Explain piconet?

1007

Whether dimension table can have numeric value?

1236

What is a relationship?

1033

What are the different problems that ?Data mining? can solve?

2883

Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?

1197

Do you view contain data?

1003

What is data analysis?

999

What is partitioning? What are the types of partitioning?

1225

What is data warehouse architecture?

1097

What are the types of partitioning?

1078

What is Analysis Services?

2211

What are the advantages of raid 1, 1/0, and

1018

Explain what are the different types of join operations?

1015

How can we load the time dimension?

1246

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