Assume you are implementing a data warehouse project for a consumer and require to evaluate the many tools available for extracting, transforming, and loading data into the data warehouse from several sources.
Problem:
- For your client in this case, select a company that is familiar to you. Briefly describe the company and how it could benefit from a data warehouse.
- Research the leading ETL products available in the marketplace and write a comparison of their major features. You must evaluate at least three tools from ETL vendors, such as Informatics, ETI, etc.
- Select the product that you feel best meets your client's requirements and explain your reasons for selecting that product.