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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
