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?