Extract-Transform-Load

From CASRAI dictionary

Extract-Transform-Load

ETL involves the following steps: (a) Extract data from homogeneous or heterogeneous data sources which are often managed by different people. An intrinsic part of the extraction involves data validation to confirm whether the data pulled from the sources have the correct/expected values; (b) Transform the data for storing it in proper format or structure for querying and analysis purposes; An important function of transformation is the cleaning of data; and, (c) Load the data into the final target (database, operational data store, data mart, or data warehouse). ETL processes can involve considerable complexity, and significant operational problems can occur. SYNONYM. ETL

Extended Description

n/a

Translation

EN
Extract-Transform-Load
FR

Sub-elements

n/a

Used in Profiles

n/a

Meta

Version
ID a8b8978e-5787-4fdc-95c3-730b2d6d6786
Original source https://en.wikipedia.org/wiki/Extract,_transform,_load