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 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.