Skip Navigation
ELT (extract, load, transform) "provides a modern alternative to ETL" (Panoply). "Instead of transforming the data before it’s written, ELT leverages the target system to do the transformation. The data is copied to the target and then transformed in place" (Ironside).
"One of the main attractions of ELT is its reduction in load times relative to the ETL model. Taking advantage of the processing capability built into a data warehousing infrastructure reduces the time that data spends in transit and is more cost-effective. This capability is most useful for processing the large data sets required for business intelligence (BI) and big data analytics" (TechTarget).
More from the data glossary
A definitive guide to data definitions and trends, from the team at Stitch.
- Analytics
- Big data
- Business intelligence (BI)
- Common table expression
- Data analytics
- Data architecture
- Data engineering
- Data enrichment
- Data exploration
- Data ingestion
- Data integration
- Data lake
- Data migration
- Data mining
- Data modeling
- Data pipeline
- Data preparation
- Data science
- Data visualization
- Data warehouse
- Data Wrangling: Definition and Examples
- Database
- Deduplication
- ELT
- ESB - What is an Enterprise Service Bus?
- ETL
- ETL pipeline
- Information lifecycle management (ILM)
- Machine learning
- Master data management (MDM)
- SaaS
- Service-oriented architecture (SOA)
Give Stitch a try, on us
Stitch streams all of your data directly to your analytics warehouse.
Set up in minutesUnlimited data volume during trial