If there is a process flow where I have a source file which may have new records as well as the once which are already existing in the database. Now I would like to only insert the records and skip the update records.
Right now in the database target I have only insert selected. But then if it finds a record which is already there it fails because it sees duplicate primary key. I would like the process flow to continue inserting records and skipping the update records instead of primary key constraint error and stopping the process. How do I do it?
Post is closed for comments.