Unique Records via BIP for tables with Object Version Number
SummaryI'm looking for a way to obtain the latest information for a given record via a BIP job, for tables with an Object_Version_Number column
As per the subject, I'm looking to try and find a way to return unique records from a table with Object Version Number.
For example, a unique list of roles available in the application.
Both per_roles_dn_tl, and per_roles_dn hold the column "OBJECT_VERSION_NUMBER". My understanding is that this is related to API calls, and that the number increments as the records are updated.
However, this means that there are duplicate records held on the table for each role. I don't want to use a distinct function, as this will effectively give me a random row each time, rather than the latest record for each role.