ETL PROCESS
The three-stage ETL process and the ETL tools implementing the concept might be a response for the needs described above.
The ‘ETL’ shortcut comes from 'Extract, transform, and load' – the words that describe the idea of the system. The ETL tools were created to improve and facilitate data warehousing.
- The Etl process consists of the following steps:
- Initiation
- Build reference data
- Extract from sources
- Validate
- Transform
- Load into stages tables
- Audit reports
- Publish
- Archive
- Clean up
Sometimes those steps are supervised and performed indirectly but its very time-consuming and may be not so accurate.
The purpose of using ETL Tools is to save the time and make the whole process more reliable.
The purpose of using ETL Tools is to save the time and make the whole process more reliable.