Data Warehousing ETL Checklist
Created on: Jul 22, 2009 10:52 AM by MichaelStevens - Last Modified: Jul 22, 2009 10:53 AM by MichaelStevens
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
Related Knowledge Network Content
There are no comments on this document
All About Reducing Your IT Costs
Looking to cut costs? Use this research-driven Excel tool to pinpoint which IT cost reduction measures best fit your needs.
The Complete IT Policy Kit
Download a comprehensive bundle containing over 40 IT policy templates. Each can be modified to align with your specific business requirements. Complete instructions are included.
