ETL Tutorial | What is ETL Process? (Extract Transform Load)
This ETL tutorial will explain what is ETL process and what it mean in a technical way. ETL is a very important concept that every IT professional should understand if they deal with data projects.
ETL tools combine three important functions (extract, transform, load) required to get data from one data environment and put it into another data environment.
Topics covered in this video:
Extraction Process and its Strategies
Transformation and various tasks performed
Loading Process and its Strategies
ETL tools and its features.
ETL Tools: Talend Open Studio, Jaspersoft ETL, Ab initio, Informatica, Datastage, Clover ETL, Pentaho ETL, Kettle
ETL Tools Features:
Source and Target Data System Connectivity
Scalability and Performance
Easy Transformation connectors
Data Cleaning and Quality
Easy integration with Web services
Logging and Exception Handling
Robust Administration features
Efficient Batch and Real time processing
Written by admin