Extract, Load, Transform (ELT)

Extract, Load, Transform (ELT) is a data integration process for transferring raw data from a source system to a target database and then preparing the information for downstream uses.

DW software

Looking for something else?

TECHNOLOGIES
ETL
+ Show More

Extract, Load, Transform (ELT) is a data integration process for transferring raw data from a source server to a data warehouse on a target server and then preparing the information for downstream uses. 

ELT is a variation of the Extract, Transform, Load (ETL), a data integration process in which transformation takes place on an intermediate server before it is loaded into the target. In contrast, ELT allows raw data to be loaded directly into the target and transformed there. This capability is most useful for processing the large data sets required for business intelligence (BI) and big data analytics.

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 was first published in August 2013

Continue Reading About Extract, Load, Transform (ELT)

Glossary

'Extract, Load, Transform (ELT)' is part of the:

View All Definitions

Dig deeper on Data warehouse software

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

File Extensions and File Formats

Powered by:

SearchBusinessAnalytics

SearchAWS

SearchContentManagement

SearchOracle

SearchSAP

SearchSOA

SearchSQLServer

Close