A more modern ETL process
ETL, or Extract-Transform-Load, solutions have been the mainstay of how companies moved data into the data warehouse to prepare it for data analytics. However, the migration from on-premise to cloud-based data warehouses is fundamentally changing the ETL process.
ELT, or Extract-Load-Transform, is a more modern approach to migrating, integrating and preparing data for data analytics. ELT means you extract data from the source, load it unchanged into a target platform – such as a cloud data warehouse – and then transform the data afterward to make it ready for use. By harnessing the power of the cloud, this new process overcomes many of the challenges of traditional ETL – such as complexity, inflexibility, low speed, and high cost.