I'm working in an Oracle database, where there are multiple duplications of features with matching geometry that shouldn't be in a table named "TDS71"."METADATASRF". There are millions of records, and I haven't found a native FME transformer that can handle this in a timely manner (Matcher, AreaOnAreaOverlayer, etc). So I'm experimenting with deleting the duplicates in SQLCreator. For now, I'm simply just trying to return all but 1 of the duplicated geometries, and will worry about deleting after I can identify them.
The code below is returning many more features than expected. I'm not really sure why to be honest. For example, a feature is duplicated 6 times in the database. From the query I have currently, 15 records are returned. Does anyone have experience doing this in SQLCreator/Executor?
select a.OBJECTID, a.SHAPE
from "TDS71"."METADATASRF" a join "TDS71"."METADATASRF" b
on sdo_relate(a.SHAPE, b.SHAPE, 'mask=equal') = 'TRUE'
and a.OBJECTID < b.OBJECTID
