ETL : Data Extraction - Pointers
Srivatsan Aravamudan Nemili / Mar 16, 2015
Extract, Transform and Load (ETL) refers to three separate functions combined into a single programming tool. First, the extract function reads data from a specified source database and extracts a desired subset of data. Next, the transform function works with the acquired data - using rules or lookup tables, or creating combinations with other data - to convert it to the desired state. Finally, the load function is used to write the resulting data which can be used for further reporting or analysis.