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!

Using Max or Min or rank in Mapping

mmoayedSep 3 2019 — edited Sep 5 2019

Hello every one,

i have to a table which contains Partner id and date . i wan for each partnet Id to select Partnter id where its date is max. and in another scenario I want to select partner id where date is max but in this case I want to add rank to select max or minimum rank number .

How can I do this using ODi Mapping without using embbeded SQL in Mapping ?

BR,

Mohammed

This post has been answered by Rodrigo Radtke Souza on Sep 4 2019

Jump to Answer

Added on Sep 3 2019

#business-intelligence-applications, #data-integrator, #system-management-and-integration

8 comments

3,972 views