ETL Tutorial

What is ETL, ETL concepts, ETL tools comparison - SSIS, Informatica, Datastage, Ab Initio etc

This section of DataWG.com covers ETL lessons useful for novice ETL developers as well as experts. Tutorial covers various articles focusing on basic concepts about extract-transform-load in data warehousing and business intelligence context. Topics covered include ETL guidelines, ETL designs, ETL processes, best practices, ETL concept, ETL software comparisons and more.

ETL - Extracting Transforming Loading
Extract - Extracting data from one or more sources
Transform - Transforming it to fit operational needs
Load - Loading it into the end target

Some of the leading ETL tools in the market are:

  • Informatica PowerCenter
  • IBM Websphere DataStage
  • Oracle Warehouse Builder
  • Ab Initio
  • Pentaho Data Integration - Kettle
  • Microsoft SQL Server Integration Services (SSIS)
  • SAS ETL studio
  • Cognos Decisionstream
  • Business Objects Data Integrator (BODI)
List below covers ETL articles on ETL best practices, real-life ETL challenges, design tips, comparative analysis of ETL tools and more:
# Article Title
1 Comparison - Datastage vs Informatica
2 Jitterbit - Open source ETL tool review
3 Talend Open Studio - Open source ETL tool review
4 Pentaho Kettle - Open source ETL tool review
5 Leading Open source ETL tools
6 ETL process best practices
7 ETL performance optimization tips
8 Challenges for Real time ETL
9 Four layered ETL architecture design
10 ETL - Data warehousing project life cycle
11 Real-life execution ETL life cycle
12 Where does ETL fits in Data Warehousing?
Home ETL

BI & DW - Interview questions | Insomnia articles | Job interview questions with answers