Asset Publisher

Data Warehouse Series - Getting from Source to Target

The fourth presentation in our Data Warehouse Series focuses on the Extraction, Transformation and Loading system (ETL). The ETL system is the foundation of the data warehouse. It accounts for the back office processes that populate the end user facing stars (which we discussed in our previous sessions). A successful implementation of your ETL system will ensure that the data warehouse can adapt to business changes in a very manageable way. This presentation introduces the BI enthusiast to a solid, Kimball based, approach to designing and implementing the ETL system.

Our one-hour presentation features:

  • Defining the Extraction, Transformation and Loading Process
  • Initial Loads versus Incremental Loads
  • Change Data Capture (CDC)
  • Other strategies: i.e. ELT
  • Why use ETL tools versus procedural language