I am working on a File-XI-JDBC scenario. My requirement is that before inserting the records in the database it should first check what all entries are already existing in the database wrt a particular column value. If an entry is found in the database then that entry should not be inserted rest all data should be inserted.
I have tried with UPDATE & INSERT command at receiver end but it is not checking for the existing records.
Kindly guide me on this.