ETL (Extract-Transform-Load) | Data Integration Info
Main menu ETL (Extract-Transform-Load) ETL comes from Data Warehousing and stands for Extract-Transform-Load. ETL covers a process of how the data are loaded from the source system to the data warehouse. Currently, the ETL encompasses a cleaning step as a separate step. The sequence is then Extract-Clean-Transform-Load. Let us briefly describe each step of the ETL process. Process Extract The Extract step covers the data extraction from the source system and makes it accessible for further processing. The main objective of the extract step is to retrieve all the required data from the source system with as little resources as possible. The extract step should be designed in a way that it does not negatively affect the source system in terms or performance, response time or any kind of locking. There are several ways to perform the extract: Update notification - if the source system is able to provide a notification that a record has been changed and describe the change,Read full article from ETL (Extract-Transform-Load) | Data Integration Info
No comments:
Post a Comment