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

    Support for Oracle analytical functions in Teiid ?

    Masilamani Subramanyam Newbie

      Hello,

       

      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