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?

975

How to reduce warnings?

901

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

1016

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

905

Explain meta data?

956

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

974

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

890

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

949

How can we determine what records to extract?

1029

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

942

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

944

Explain some of modeling tools available in the market?

899

Explain what are non-additive facts?

962

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

936

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

880

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is a Decision Tree Algorithm?

4948

Explain conformed fact?

902

How did you plan your Data ware house project?

2243

What is the main difference between schema in rdbms and schemas in datawarehouse?

1023

What is an er diagram?

980

What is the use of tabular model, tabular sql, tabular reference in real time application?

909

What is the main difference between star and snowflake star schema? Which one is better and why?

975

Explain normalization?

1050

What is application.cfm?

1001

Explain why denormalization is promoted in universe designing?

908

What are the different types of join operations?

938

How can you set the client management?

958

Can you state some of the innovations throughout history?

930

What needs to be done while starting the database?

1050

What are situations where snowflake schema is better than star schema when the opposite is true?

932

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