Staging-Area (EN)

Concept

Temporary storage area for data during the ETL process

Architecture

flowchart LR   A[Source systems] --> B[Extraction]   B --> C[Staging-Area]   C --> D[Transformation]   D --> C   C --> E[Loading]   E --> F[Target system]

In Context

  • Typically used together with ETL/ELT processes
  • Related to: Data Warehouse, Data quality, Data cleansing
  • Example use: Daily loading of transaction data from ERP systems into a Data Warehouse
Quelle: AI Generated