🧭Extract, Transform, Load (ETL)
Also known as ETL, ETL Pipeline
Pull data out. Clean it on the way. Then load it in.
Think of it like
It is like washing fruit at the farm. Then you put it in the fridge.
Example
A hospital pulls out each day's visits at night. It takes out the names. Only the clean rows go into the report tables.
Why it matters
Cleaning first keeps raw and private data out of the warehouse. It also keeps the warehouse small.
Definition
Common mistake
Key takeaways
- 1Extract. Read the data from the source.
- 2Transform. Clean it before it lands.
- 3Load. Write only the finished data.