Primary key constraint error
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?
This can be easily done you have to just take care of below two things:
1. While Creating Database Target Select "Database Operation" as Insert.
2. In Process Flow Double click on Database Target activity and Select Error Records as "File' from dropdown.0
Post is closed for comments.