ELT
Extract, load, transform: copying data from its source into a destination system as it is, and cleaning and reshaping it there afterward.
Because the raw copy is kept, a transformation can be corrected and run again without going back to the source. The same raw copy means uncleaned data sits in the destination, where it can be used by mistake.
See also
- ETLExtract, transform, load: taking data out of a source system, cleaning and reshaping it, and then writing the result into a destination.
- Raw dataData exactly as it was received or collected, before anything has been corrected, reformatted, or removed.
- TransformationAny step that turns data from one form into another: converting a type, splitting a column, combining tables, or calculating a new field.