ETL: Difference between revisions

From ACT Wiki
Jump to navigationJump to search
imported>Doug Williamson
(Create page. Source - Data Analytics Newsletter - 14 June 2023.)
 
imported>Doug Williamson
(Update wording.)
 
(One intermediate revision by the same user not shown)
Line 3: Line 3:
Abbreviation for Extract, Transform, Load.
Abbreviation for Extract, Transform, Load.


A process of data handling between systems that first Extracts data from the first system and then Transforms it for use by the second system.


Only then is the data Loaded into the second system.
A process of data handling between two systems in which we first Extract data from the first system, and next Transform the raw data for use by our second system.
 
Only then do we Load our transformed data into our second system.




Line 12: Line 13:
* [[Data cleansing]]
* [[Data cleansing]]
* [[Database]]
* [[Database]]
* [[ETL]]
* [[ELT]]
* [[Information technology]]
* [[Information technology]]
* [[Transformation]]
* [[Transformation]]

Latest revision as of 07:41, 15 June 2023

Data - databases - data cleansing.

Abbreviation for Extract, Transform, Load.


A process of data handling between two systems in which we first Extract data from the first system, and next Transform the raw data for use by our second system.

Only then do we Load our transformed data into our second system.


See also