Data Warehousing ETL Checklist
ETL — Extract, Transform and Load — is the process by which data from multiple systems is consolidated, typically in a data warehouse, so that executives can obtain a comprehensive picture of business functions, e.g. the relationships between marketing campaigns, sales, production and distribution. It has been estimated that in any data integration project, ETL will consume 60 to 70 percent of the time and resources.
The process is complicated and has been the subject of numerous books. Anyone undertaking an ETL project for the first time will have to do some serious research. Here is a high-level checklist of the important topics.
The attached Zip file includes:
- Intro Page.doc
- Cover Sheet and Terms.pdf
- Data Warehousing ETL Checklist.doc