Delivering ETL Change Data Capture (CDC) - Part 1

I’ve used a number of ETL product sets in my career to date and am interested in how they take different approaches to perform regularly required tasks. A good example is the  comparison between SAP Business Data Integrator 11.7 (BODI) and SQL Server Integration Services (SSIS) 2005.  It is not particularly useful to compare these two products on terms such as speed, performance or efficiency.  The tools are functionally very different. In SSIS, data is loaded into memory and the work is carried out within the engine so an increase in physical memory means better performance, whereas BODI allows some less complex operations to be pushed down to the database at run time while processing the complex transformations in memory.