Data Warehousing ETL Checklist

132 KB | 3 files | null DOC,null PDF

ETL (Extract, Transform and Load) is a key, and very complicated, component of a data management strategy. This high-level checklist of the most central issues will help you get started with this critical data warehousing issue.

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
IT Downloads help you save time and money while executing essential IT management tasks. Download this useful resource now and put it to work for your business.
Related IT Downloads

Infra4 Microsoft Project 2013 Cheat Sheet

Microsoft Project 2013 is a project management software program that helps you plan projects and keep them on track, no matter how big or small. ...  More >>

Risk Management: Concepts and Guidance

The excerpt from chapter 5 focuses on the ins and outs of preparing for and running a risk management planning meeting, including necessary resources and expected outcomes. ...  More >>

ProjectMgmt2TN Creative, Efficient, and Effective Project Management

Chapter 7, excerpted here, focuses on creativity life cycle models. Contrary to popular belief, creativity requires having some type of discipline in place to allow it to be further exercised and result in something that is understandable and meaningful to others. ...  More >>

Subscribe Daily Edge Newsletters

Sign up now and get the best business technology insights direct to your inbox.