Unique records from external system

Question

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.

stefanhelzle0001 · Answer

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.

Sign up

Login with SSO

Login to the community

Login with SSO