Editing Extract, transform, load (section)

=== Additional phases ===

A real-life ETL cycle may consist of additional execution steps, for example:

# Cycle initiation
# Build [[reference data]]
# Extract (from sources)
# [[data validation|Validate]]
# Transform ([[data cleaning|clean]], apply [[business rule]]s, check for [[data integrity]], create [[Aggregate (data warehouse)|aggregates]] or disaggregates)
# Stage (load into [[staging (data)|staging]] tables, if used)
# [[Audit report]]s (for example, on compliance with business rules. Also, in case of failure, helps to diagnose/repair)
# Publish (to target tables)
# [[Archiving|Archive]]