ETL Design

Structured approach to planning extraction, transformation and loading of data between systems with a focus on reliability and maintainability.

ETL design is a structured approach to extracting, transforming, and loading data between systems.

Maturity

Established

Cognitive loadMedium

360° overview

Six perspectives place the building block in context. The numbers show where each perspective continues in the reading path.

The building block at a glance

ETL Design

360°

2

2

Integrations

Databases (Postgres, MySQL, Oracle)

+2

1

Explicit separation of extraction, transformation and loading

Value stream stage: Build

4

3

4