Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MAX without group by in ODI interface

J.deZwartSep 26 2016 — edited Sep 26 2016

Hi there,

Is it possible to have a mapping like : MAX ( <column> ) OVER (PARTITION <column>) without getting a group by clause with the same mapping ?

It seems that when I make this mapping, the KM generates an SQL statement with

GROUP BY MAX( <column> ) OVER (PARTITION <colum> )

Is it possible to 'turn' the group clause off ?

I'm using ODI 11.1 with BIAPPS.

Thanks in advance,

Jacco
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 24 2016
Added on Sep 26 2016
#business-intelligence-applications, #data-integrator, #mapping, #odi, #system-management-and-integration
3 comments
920 views