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 is fact less fact table? Where you have used it in your project?

935

What does level of granularity of a fact table signify?

1097

What are the different methods of loading dimension tables?

996

Explain what are the modules in power mart?

1052

Explain what is ods (operation data source)?

996

Explain difference between data ware house & data mart?

993

Explain what is the difference between view filter and report filter?

986

What is data type of the surrogate key?

1004

Where the applications and where ware house management system is used?

1018

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?

927

What is the difference between power center & power mart?

986

Explain what are conformed dimensions?

1093

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

964

How to calculate fact table granularity?

1025

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?

1065

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is is a star schema?

1179

Database in use is oracle?

1057

How to limit the max no of rows retrieved in the report?

986

Explain what is full load & incremental or refresh load?

993

Explain what are the steps to build the data warehouse?

954

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

1033

What is prompt types of prompts?use of prompts syntax of prompt?

1349

Explain what are the advantages and disadvantages of reporting directly against the database?

1003

What is real-time datawarehousing?

1030

Explain how to export mappings to the production environment?

980

What are the approaches used by optimizer during execution plan?

911

What is hybrid slowly changing dimension?

1037

What are the steps of implementing data warehousing?

1049

How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

1078

Explain what are the various file formats involved in reportnet?

947

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