Data warehousing Interview Question and Answers

1. What is a data warehouse?
 
  • A data warehouse is a database designed to support a broad range of decision tasks in a specific organization.
  • It is usually batch updated and structured for rapid online queries and managerial summaries.
  • Data warehouses contain large amounts of historical data which are derived from transaction data, but it can include data from other sources also.
  • It is designed for query and analysis rather than for transaction processing.
  • It separates analysis workload from transaction workload and enables an organization to consolidate data from several sources.
  • The term data warehousing is often used to describe the process of creating, managing and using a data warehouse.
 
Your Name Your Email-ID
Your Answer
2. What are the characteristics of a data warehouse?
 
  • Data in a data warehouse is organized as subject oriented rather than application oriented.
  • It is designed and constructed as a non–volatile store of business data, transactions and events. Data warehouse is a logically integrated store of data originating from disparate operational sources.
  • It is the only source for deriving information needed by the end users. Several temporal modeling styles are usually used in different areas of the data warehouse.
 
Your Name Your Email-ID
Your Answer
3. What are the benefits of data warehousing?
  Some of the potential benefits of putting data into a data warehouse include:
  • Improving turnaround time for data access and reporting.
  • Standardizing data across the organization so there will be one view of the "truth".
  • Merging data from various source systems to create a more comprehensive information source.
  • Lowering costs to create and distribute information and reports.
  • Sharing data and allowing others to access and analyze the data.
  • Encouraging and improving fact-based decision making.
 
Your Name Your Email-ID
Your Answer
4. What is mean by SCD?
  Slowly Changing Dimension: A dimension whose data changes over time.The term slowly emphasizes the fact that the data in a dimension changes less frequently than the data in related facts.
 
Your Name Your Email-ID
Your Answer
12345678910 Page 1 of 10