Whitepaper – Thirteen Factors Crippling ETL Productivity
ETL design, implementation, and maintenance is often very time consuming (and can be error-prone) in complex batch data integration projects (e.g. a Data Warehouse), often consuming as much as 80% of the overall effort.
This whitepaper describes 13 factors that either enable or limit good productivity on ETL projects and compares how SQL Server® Integration Services and actionETL™ .NET Library performs on these factors.
Many of the conclusions also apply to other graphical ETL tools.