Process / pipelineData Pipeline & Integration
ETL Process
The Extract-Transform-Load (ETL) process is a systematic approach to moving data from source systems into a target repository. Formalized in the context of data warehousing, ETL pipelines extract data from diverse operational sources, apply business rules and data quality checks, and load the results into data warehouses and analytical systems.
Open in MethodMindSoonVideoSoon
Read the full method
Members only
Sign inSign in with a free account to read this section.
Sources
- Kimball, R. (1996). The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses. New York: John Wiley & Sons. link ↗
- Kakish, K., & Kraft, T. (2012). The six pillars of enterprise data quality. DM Direct, 5(6), 44-47. link ↗
- Vassiliadis, P., Quix, C., Vassalos, V., & Jarke, M. (2000). Data warehouse process management. Information Systems, 25(2), 111-125. DOI: 10.1016/S0306-4379(00)00011-6 ↗