flâneur — a map of the web's best reading

Extract, transform, load - Wikipedia

en.wikipedia.org · 5,108 words · saved by 1 readers

Extract, transform, load (ETL) is a three-phase computing process where data is extracted from an input source, transformed (including cleaning), and loaded into an output data container. The data can be collected from one or more sources and it can also be output to one or more destinations. ETL processing is typically executed using software applications but it can also be done manually by system operators. ETL software typically automates the entire process and can be run manually or on recurring schedules either as single jobs or aggregated into a batch of jobs. A properly designed ETL system extracts data from source systems and enforces data type and data validity standards and ensures it conforms structurally to the requirements of the output. Some ETL systems can also deliver data in a presentation-ready format so that application developers can build applications and end users can make decisions.[1] The ETL process is often used in data warehousing.[2] ETL systems commonly int

Extract, transform, load - Wikipedia Jump to content From Wikipedia, the free encyclopedia Procedure in computing This article needs more citations . Please help improve this article by adding citations to reliable sources . Unsourced material may be challenged and removed . Find sources: "Extract, transform, load" – news · newspapers · books · scholar · JSTOR ( September 2024 ) ( Learn how and when to remove this message ) Conventional ETL architecture Data transformation Concepts Metadata Data element Data mapping Data migration Data transformation Model transformation Macro Preprocessor Tra

Explore this link on the map →

related reading