Chapter 6

Extract, Transform, and Load

Information in this Chapter

What is ETL?

The core function of data integration is to obtain data from where it currently resides, changing it to be compatible in format with the desired destination and putting it into the destination system. These three steps are called extract, transform, and load (ETL). All data integration, regardless of whether it is performed in batch or real time, synchronously or asynchronously, physically or virtually, revolves around these basic actions. Although it is an extremely simple concept, large possible differences in designs and ...

Get Managing Data in Motion now with O’Reilly online learning.

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