Image Posted on
Q: Define Data Warehouse?
A: Data warehouse is Subject Oriented, Integrated, Time-Variant and Nonvolatile collection of data that support management’s decision making process.
Q: What does the subject oriented data warehouse signifies?
A: Subject oriented signifies that the data warehouse stores the information around a particular subject such as product, customer, sales etc.
Q: List any five applications of Data Warehouse?
A: Some applications include financial services, Banking Services, Customer goods, Retail Sectors, Controlled Manufacturing.
Q: What does OLAP and OLTP stand for?
A: OLAP is acronym of Online Analytical Processing and OLAP is acronym of Online Transactional Processing
Q: What is the very basic difference between data warehouse and Operational Databases?
A: Data warehouse contains the historical information that is made available for analysis of the business whereas the Operational database contains the current information that is required to run the business.
Q: List the process that are involved in Data Warehousing?
A: Data Warehousing involves data cleaning, data integration and data consolidations.
Q: List the functions of data warehouse tools and utilities?
A: The functions performed by Data warehouse tool and utilities are Data Extraction, Data Cleaning, Data Transformation, Data Loading and Refreshing
Q: What do you mean by Data Extraction?
A: Data Extraction means gathering the data from multiple heterogeneous sources.
Q: Define Metadata?
A: Metadata is simply defined as data about data. In other words we can say that metadata is the summarized data that lead us to the detailed data.
Q: What does Meta Data Respiratory contains?
A: Metadata respiratory contains Definition of data warehouse, Business Metadata, Operational Metadata, Data for mapping from operational environment to data warehouse and the Algorithms for summarization.