Advertisement

ETL Processing with SQL

  • Randal Root
  • Caryn Mason

Abstract

The ETL process, and projects associated with it, involve extracting vital information from outside sources, transforming data into clean, consistent, and usable data, and loading it into the data warehouse. This process is vital to the success of your BI solution. It is what makes the difference between a professional, functional data warehouse versus one that is messy, insufficient, and unusable. The ETL process is also one of the longest and most challenging steps in developing a BI solution.

Keywords

Lookup Table Data Warehouse Select Statement Query Window Abstraction Object 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Randal Root and Caryn Mason 2012

Authors and Affiliations

  • Randal Root
  • Caryn Mason

There are no affiliations available

Personalised recommendations