Extract, Transform, Load (ETL): Difference between revisions
Jump to navigation
Jump to search
WendyGeller (talk | contribs) (Created page with "ETL is the process of: *Extracting data from a source such as a database, csv file, or EXCEL file. *Transforming the data if necessary (i.e., formatting to CEDS, converting number to text, performing a lookup and replacement, etc.). *Loading the data into a database or exporting to a data file (i.e., .csv, .xlsx).") |
(No difference)
|
Latest revision as of 15:28, 7 March 2023
ETL is the process of:
- Extracting data from a source such as a database, csv file, or EXCEL file.
- Transforming the data if necessary (i.e., formatting to CEDS, converting number to text, performing a lookup and replacement, etc.).
- Loading the data into a database or exporting to a data file (i.e., .csv, .xlsx).