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

Explain what are the various transformation available?

1024

How to reduce warnings?

937

What is the difference between a primary and secondary actor in use case modeling?

1066

Explain what is partitioning? What are the types of partitioning?

973

Explain meta data?

1032

Explain why are oltp database designs not generally a good idea for a data warehouse?

1030

Tell me what is full load & incremental or refresh load?

950

Explain is olap databases are called decision support system true/false?

1005

How can we determine what records to extract?

1081

What is a staging area? Do we need it? What is the purpose of a staging area?

996

Explain which are the olap tools available that are supported by oracle?

1009

Explain some of modeling tools available in the market?

968

Explain what are non-additive facts?

1033

Explain what is the difference between power center & power mart?

999

Explain if a flat file cotains 1000 records how can I get first and last records only?

931

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is the difference between drill through and masterdetail reports?

1162

What are the different types of join operations?

1002

Explain which are the olap tools available that are supported by oracle?

1009

What are the various methods of getting incremental records or delta records from the source systems?

931

What is difference between model & package?

1029

What is the difference between static cache and dynamic cache?

993

What are the stages that are required in data warehousing?

964

Explain me what are data marts?

1048

Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?

1027

What is pre-emptive and non-pre-emptive?

977

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

2831

how much memory space occupied real time project (roughly)?

2222

Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?

923

What is the difference between ods and oltp?

1018

What is conformed fact?

1094

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