Data Transformation Process

The main source of the transactional data which could be your SAP,Oracle,Excel Data is cleaned, transformed, catalogued into a Data Respository and made possible through the use couple of ETL(Extract Load and Transform)Tools such as Business Objects Integrator and Microsoft Integration Services amongst a plethora of off the shelf ones. Below is an extract showing the ETL process using Microsoft Integration Services processing data from a Data Source to a Data Repository.