Developing ETL code and attempting to achieve the ultimate business solution can have its challenges. There is always “a need for speed” or real-time business analysis. Using database analytical functions offered by leading database providers (e.g. Oracle, DB2, Microsoft SQL Server 2005 and Teradata) a developer can cut down on the amount of processing within the ETL tool and allow the database to assist with the processing.