Adapter Online Help > TDV Oracle Adapter > Oracle Function Support > Oracle Analytic Function Support
 
Oracle Analytic Function Support
TDV supports the analytic functions listed in the table below for Oracle.
Analytic functions are commonly used in data warehousing environments. They are all push-only functions.
Oracle Analytic Function
Notes
CORR
 
COUNT
 
COVAR_POP
 
COVAR_SAMP
 
CUME_DIST
 
DENSE_RANK
 
FIRST_VALUE
 
LAG
 
LAST_VALUE
 
LEAD
 
LISTAGG
Version 11g R2. Pushed. (Aggregate LISTAGG function is supported in TDV.
MAX
 
MEDIAN
MEDIAN (DISTINCT) not supported.
MIN
 
NTILE
 
PERCENT_RANK
 
PERCENTILE_CONT
 
PERCENTILE_DISC
 
RANK
 
RATIO_TO_REPORT
 
ROW_NUMBER
 
SUM