ETL (Extract, Transform, Load)


ETL is short for extract, transform, load, three database functions that are combined into one tool to pull data out of one database and place it into another database.

Extract is the process of reading data from a database.
Transform is the process of converting the extracted data from its previous form into the form it needs to be in so that it can be placed into another database. Transformation occurs by using rules or lookup tables or by combining the data with other data.
Load is the process of writing the data into the target database.

ETL is used to migrate data from one database to another, to form data marts and data warehouses and also to convert databases from one format or type to another.

Read Also:

  • ETNO

    Acronym for The European Telecommunications Network Operators’ Association. The European Telecommunications Network Operators’ Association was established in May 1992 and has become the principal policy group for European electronic communications network operators. ETNO’s primary purpose is to establish a constructive dialogue between its member companies and decision-makers and other actors involved in the development of […]

  • ETOM

    Short for electron-trapping optical memory. Developed by Optex, ETOM is a method of erasable optical storage. Information is written, or stored, by a low-power laser tuned to a specific frequency. The laser elevates the energy level of electrons to a trapped state. The data is read by a second laser that returns the elevated electrons […]

  • ETRN

    Short for Extended Turn, an extension to the SMTP mail delivery protocol that allows an SMTP server to request from another SMTP server any e-mail messages it has for a specific domain. ETRN typically is used to retrieve e-mail messages from a mail server that does not have a dedicated connection to the Internet. ETRN […]

  • ETSI

    The European Telecommunications Standards Institute (ETSI) is an independent, non-profit organization, whose mission is to produce telecommunications standards for today and for the future. Based in Sophia Antipolis (France), the European Telecommunications Standards Institute (ETSI) is officially responsible for standardization of Information and Communication Technologies (ICT) within Europe. These technologies include telecommunications, broadcasting and related […]

  • End-User License Agreement EULA

    Short for End-User License Agreement, the type of license used for most software. An EULA is a legal contract between the manufacturer and/or the author and the end user of an application. The EULA details how the software can and cannot be used and any restrictions that the manufacturer imposes (e.g., most EULA��s of proprietary […]


Disclaimer: ETL (Extract, Transform, Load) definition / meaning should not be considered complete, up to date, and is not intended to be used in place of a visit, consultation, or advice of a legal, medical, or any other professional. All content on this website is for informational purposes only.