Hi All,
Through Integration I am fetching the data from external system and storing it into my system. But it also stores duplicate records which already exists into my system. How should I prevent this, if I compare each row with existing data it would be time consuming. Please suggest.
Discussion posts and replies are publicly visible
I do not see any other option than to compare every record before adding it to the system. Depending on how you design that mechanism, you can do queries in batch. So when you get 10 records, you can query for duplicates for all of them in one query, instead of doing a separate query for each.