ETL-Prozesse (EN)

Concept

Processes for extracting, transforming and loading data

ETL Process Flow

flowchart TD     A[Source Systems] --> B[Extraction]     B --> C[Transformation]     C --> D[Loading]     D --> E[Data Warehouse]          subgraph Transformation         C1[Data Cleansing]         C2[Formatting]         C3[Validation]         C1 --> C2         C2 --> C3     end          B --> C1     C3 --> D

In Context

  • Typically used together with Data Warehouse systems and Business Intelligence tools
  • Related to: ELT processes, data pipelines, Data Mining
  • Example use case: Aggregation of sales data from various shops into a central Data Warehouse
Quelle: AI Generated