Chapter 1. Introduction to ETL Development

In this chapter, we will cover:

  • Preparing a database environment
  • Creating a source system database
  • Defining and creating staging area structures
  • Creating a target data warehouse

Introduction

Simply put, Extract-Transform-Load (ETL) is an engine of any data warehouse. The nature of the ETL system is straightforward:

  • Extract data from operational databases/systems
  • Transform data according to the requirements of your data warehouse so that the different pieces of data can be used together
  • Apply data quality transformation methods in order to cleanse data and ensure that it is reliable before it gets loaded into a data warehouse
  • Load conformed data into a data warehouse so that end users can access it via reporting ...

Get SAP Data Services 4.x Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.