ETL Tutorial
ETL tutorial
ETL tool, ETL data, ETL software, ETL data warehouse design, etl tools, abinitio, datastage, ssis etc
T
his section of DataWG.com covers ETL lessons useful for novice ETL developers as well as experts. Tutorial covers various articles focussing on basic concepts about extract-transform-load in data warehousing and business intelligence context. Also about ETL guidelines, ETL designs, ETL processes, best practices and many more concepts. Special focus will be given on emphasizing how to use some of the widely used ETL tools in the market. This section will be a knowledge base for most of the ETL related articles covering ETL management and implementation.Focus of the tutorial will be on:
- Give a detail account of some of the real life ETL problems
- ETL design concepts & best practices
- Typical ETL architectures
- Comparative analysis of various ETL tools available in the market
- How to use some of the ETL tools(SSIS, informatica, datastage etc)
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)