Extract, load, transform

<p>Extract, load, transform (ELT) is an alternative to <a href="/facts/Extract%2c_transform%2c_load/WRaRgJL5">extract, transform, load</a> (ETL) used with <a href="/facts/Data_lake/0CA7G5k0">data lake</a> implementations. In contrast to ETL, in ELT models the <a href="/facts/Data/AUBFN97o">data</a> is not transformed on entry to the data lake, but stored in its original raw format. This enables faster loading times. However, ELT requires sufficient processing power within the <a href="/facts/Data_processing/74EKCDAq">data processing</a> engine to carry out the transformation on demand, to return the results in a timely manner. Since the data is not processed on entry to the data lake, the query and schema do not need to be defined a priori (although often the schema will be available during load since many data sources are extracts from databases or similar structured data systems and hence have an associated schema). ELT is a data <a href="/facts/Pipeline_(computing)/xmHjrPMP">pipeline</a> model.
</p>

Extract, load, transform open-in-new

Extract, load, transform