8 Replies Latest reply on Jan 28, 2013 8:56 AM by Steven Hawkins

    Support for Oracle analytical functions in Teiid ?

    Masilamani Subramanyam Newbie



      Is Teiid supports Oracle Analytical functions which should be push-down function to oracle data source?  I looked at the source function feature which seems to be only for scalar functions but does not support analytical functions as shown below. 


      Function(arg1,..., argn) OVER ( [PARTITION BY <...>] [ORDER BY <....>] [<window_clause>] )


      Example:  ROW_NUMBER( ) OVER (PARTITION BY deptno ORDER BY hiredate NULLS LAST) RNO

                       COUNT(*) OVER (PARTITION BY deptno) DEPT_COUNT


      Thanks, Mani