Data Warehouse Cloud data flow - Check target table for duplicate entries

[#1]

Hello experts,

currently we are trying to insert data into a table via DWC data flow. Now we want to prevent that the data flow creates duplicate entries in the target table. Problem is that the field we have to check is NOT a primary key.

EDIT: The primary key UUID is also used saved on other tables ad referenced via association.

The db table itself has a UUID as primary key and a second data field "example" for a string 100. We need to check if there is already a entry in the table (e.g. "Foobar" in data field "example").

Which approach would you recommend inside the data flow?

BR,

Christian

[Sven_Knpfler]

Hello Christian,

you could use the delete mode in the data flow:

1. First you would delete all the records in the target that come from the source with the same field value in this one field.

2. After that you would upsert the new records in the target.

https://help.sap.com/viewer/c8a54ee704e94e15926551293243fd1d/cloud/en-US/ae4e3b9c121e4bcc9ec46ccbc98...

Does that work for you?

Kind regards

Sven