Analytic Functions In OWB
Analytic Functions In Oracle Warehouse Builder: "Analytic Functions are an important feature of the Oracle database that allows the users to enhance SQL's analytical processing capabilities. These functions enable the user to calculate rankings and percentiles, moving window calculations, lag/lead analysis, top-bottom analysis, linear regression analytics and other similar calculation-intense data processing. This whitepaper describes how to use some of these analytical functions in the ETL (extraction, transformation and loading) processing implementation using Oracle Warehouse Builder."