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
The IT Service Catalog Management Toolkit
Bridge the IT-business gap once and for all! A well documented IT services catalog is the conduit for IT services to the rest of the company.
Select the Right Cloud Infrastructure Service Partner
Planning a Cloud implementation? This timely research bundle cuts through the hype and provides practical advice and powerful tools. It will help you understand the vendor landscape, assess which of your processes are "Cloud ready" and model total cost of ownership for a variety of scenarios.
