Extract, transform, load. In ETL the transform runs before the load; in ELT the raw data is loaded first and the warehouse transforms it.
Both patterns run on the same Lima engine. A mixed pattern does a light clean in Lima and the heavy work in the warehouse. The choice depends on where the compute is cheapest and where the checks need to run.
Sixty-nine terms in five groups.