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?

1025

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?

997

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 definition of cube in datawarehousing?

992

Explain some of modeling tools available in the market?

968

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

1116

Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?

1098

Explain what is the metadata extension?

1037

What are Aggregate tables?

1175

Explain what is type 2 version dimension?

1007

How to create different types of templates?

987

What is "method/1"?

1060

Explain the difference between data ware house & data mart?

953

Explain normalization?

1134

What are modeling tools available in the market?

978

Explain how many ways you create ports?

1024

What is load manager?

1045

How to know the time taken for particular report execution?

965

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