ETL meaning in Information Technology ?

Answer:

What is Extract, Transform, Load mean?

In computing, extract, transform, load (ETL) is the general procedure of copying data from one or more sources into a destination system which represents the data differently from the source(s) or in a different context than the source(s). The ETL process became a popular concept in the 1970s and is often used in data warehousing.

Data extraction involves extracting data from homogeneous or heterogeneous sources; data transformation processes data by data cleaning and transforming it into a proper storage format/structure for the purposes of querying and analysis; finally, data loading describes the insertion of data into the final target database such as an operational data store, a data mart, data lake or a data warehouse.

A properly designed ETL system extracts data from the source systems, enforces data quality and consistency standards, conforms data so that separate sources can be used together, and finally delivers data in a presentation-ready format so that application developers can build applications and end users can make decisions.

Since the data extraction takes time, it is common to execute the three phases in pipeline. While the data is being extracted, another transformation process executes while processing the data already received and prepares it for loading while the data loading begins without waiting for the completion of the previous phases.

ETL systems commonly integrate data from multiple applications (systems), typically developed and supported by different vendors or hosted on separate computer hardware. The separate systems containing the original data are frequently managed and operated by different employees. For example, a cost accounting system may combine data from payroll, sales, and purchasing.

reference

Full Form	Category
Epsilon Transformation Language	Academic & Science
English as a Third Language	Academic & Science
Environmental Technology Laboratory	Academic & Science
Embedded Template Library	Academic & Science
Ethernet Type LAN	Academic & Science
Educational Term Loan	Banking
Edison Testing Laboratories	Business
EADS Technology Licensing	Business
Extended Term Loan	Business
Educational Technology Leadership	Community
Enhancing Teaching Learning	Community
Effective Teaching Learning	Community
Educational Technologies Limited	Community
Endogenous Technology Learning	Community
Energy Technology List	Computing
Microsoft Event Trace Log File	Computing
Embedded Test Language	Computing
Extracting Transforming and Loading	Computing
Enhanced Transceiver Logic	Computing
European Testing Laboratory	Computing
Estimated Time of Leaving	Computing
Eclipse Transition Listing	Computing
Electronic Testing Laboratory	Computing
Embedded Transmission Line	Computing
Etherlite	Cryptocurrency
Electricity Transmission Line	Electronics
Extract Transform and Load	General
Extraction Transformation and Loading	General
Ephemerides Theologicae Lovanienses	General
Extract Transformation and Load	General
Entrepreneurial Thought Leaders	General
Extraction Tansformation and Loading	General
Executive Team Lead	General
Extract Transformation and Loading	General
Examine Translate and Leverage	General
Edison Testing Labs	General
Extract Transfer and Load	General
Electron Transport Layer	General
Early Termination Liability	General
Extract Transformation Load	General
Extraction Transforming and Loading	General
Engine Torque Limit	General
Electronic Torque Limiting	General
Economic Threshold Level	Governmental
Estimated Tour Length	Governmental
Extract, Transform, Load	Information Technology
Executive Team Leader	Jobs
Engineer Topographic Laboratories	Medical
Echo Train Length	Medical
Engineering Technical Letter	Military and Defence
Endorsed Tools List	Military and Defence
Electrical Testing Laboratory	Networking
European Turfgrass Laboratories	Regional
Essex Terminal Railway Company	Regional
Event Trace Log	Sports
Extended Trading Line	Stock Exchange