We are pulling airport data from multiple sources. In our scenario, the identifiers (IATA, ICAO, and local) for an airport can be the same but that does not mean it's a duplicate. We are keeping airport history so it is possible the codes are the same but the airport name changed or the codes were for a closed airport and are now being used by a different airport at a different location, or they are a duplicate. To be 100% sure, we need to manually determine if the two records are duplicates.
I can get the list of potential duplicates, however I do not want to merge. The data coming from the FAA is always the winning record. For our solution, we have a custom field IsActive. So the FAA records already have IsActive set to true. We have a sharing rule to only allow our external customers to see airports where IsActive is true. We have a second field IsDuplicate to indicate this is a potential duplicate.
is it possible to set the IsDuplicate flag on the losing record instead of merging. This way for those records that do not have IsDuplicate set to true we can set IsActve to true. We get a feed every night for US and international airports and it would be more work to exclude records that were merged over just marking them as a duplicate and not showing them.
