Data Integration > ETL/ELT Solution
ETL/ELT Solution
Overview
ETL is an abbreviation of Extract, Transform and Load. In this process, an ETL tool extracts the data from different RDBMS source systems then transforms the data like applying calculations, concatenations, and other operations. Then it loads the data into the Data Warehouse system.
ETL is a different method of looking at the tool approach to data movement. Instead of transforming the data before it’s written, ETL lets the target system to do the transformation. The data first copied to the target and then transformed in place.
Objective
- To visualize the process data transformation from extraction into loading to the target database.
- To minimize lack of knowledge from team member in organization who doesn’t have SQL experienced
- As a standard documentation that could be understand easily by new team member
Objective
- To visualize the process data transformation from extraction into loading to the target database.
- To minimize lack of knowledge from team member in organization who doesn’t have SQL experienced
- As a standard documentation that could be understand easily by new team member
Benefits
- Easy to maintain development of Data Transformation
- An easy to understand Create Data Flow
- To avoid losing of knowledge when the team member who created transformation has left
Powered by Technology Ecosystems
