Extract, Load, and Transform (ELT) is a process where data is extracted from various sources, loaded into a data storage system, and then transformed into the desired format within that storage system. ELT is often used in data environments where data is transformed after it is loaded, leveraging the computing power of the target system.
ELT takes advantage of the strong processing capabilities of modern data storage systems to quickly and effectively perform transformations. Because of the automation involved, it is able to scale up and handle large amounts of data easily. ELT processes also make it easier to modify or apply different transformations to a data set as needed.