Extraction: selecting data from one or more sources and read ing the selected data Transformation: converting data from their original form to whatever form the DW needs. This step often also includes cleansing of the data to remove as many errors as possible Load: putting the converted(transformed) data into the Dw 3. Why is the etl process so important for data warehousing efforts? Since etl is the process through which data are loaded into a data warehouse, a DW could not exist without it. The etl process also contributes to the quality of the data in a dw Section 3.6 Review Questions 1. List the benefits of data warehouses Direct benefits include Allowing end users to perform extensive analysis in numerous ways a consolidated view of corporate data(i.e, a single version of the truth) Better and more timely information. a data warehouse permits information processing to be offloaded from costly operational systems onto low-cost servers; therefore, end-user information requests can be cessed more qui Enhanced system performance. a data warehouse frees production processing because some operational system reporting requirements are moved to dss Simplification of data access Indirect benefits arise when end users take ad vantage of these direct benefits List several criteria for selecting a data warehouse vendor, and describe why they Six important criteria are: financial strength, ERP linkages, qualified consultants, market share, industry experience, and established partnerships. These are important to indicate that a vendor is likely to be in business for the long term, to have the support capabilities its customers need, and to provide products that interoperate with other products the potential user has or may obtain One could add others, such as product functionality(Does it do what we need?) vendor strategic vision(Does their direction make sense for our future plans Copyright C2018 Pearson Education, Inc.7 Copyright © 2018Pearson Education, Inc. Extraction: selecting data from one or more sources and reading the selected data. Transformation: converting data from their original form to whatever form the DW needs. This step often also includes cleansing of the data to remove as many errors as possible. Load: putting the converted (transformed) data into the DW. 3. Why is the ETL process so important for data warehousing efforts? Since ETL is the process through which data are loaded into a data warehouse, a DW could not exist without it. The ETL process also contributes to the quality of the data in a DW. Section 3.6 Review Questions 1. List the benefits of data warehouses. Direct benefits include: • Allowing end users to perform extensive analysis in numerous ways. • A consolidated view of corporate data (i.e., a single version of the truth). • Better and more timely information. A data warehouse permits information processing to be offloaded from costly operational systems onto low-cost servers; therefore, end-user information requests can be processed more quickly. • Enhanced system performance. A data warehouse frees production processing because some operational system reporting requirements are moved to DSS. • Simplification of data access. Indirect benefits arise when end users take advantage of these direct benefits. 2. List several criteria for selecting a data warehouse vendor, and describe why they are important. Six important criteria are: financial strength, ERP linkages, qualified consultants, market share, industry experience, and established partnerships. These are important to indicate that a vendor is likely to be in business for the long term, to have the support capabilities its customers need, and to provide products that interoperate with other products the potential user has or may obtain. One could add others, such as product functionality (Does it do what we need?), vendor strategic vision (Does their direction make sense for our future plans