I have been given an task to load a text file to a database which is simple but the file may contain the duplicate records which are already present in the DB table. So i want to load the correct records and keep other records which are not loaded to table in another text file.
text file with source data:
Now i want the rows in text file with ID=2,3 get loaded to database table and new text file is created with data 1,john and 4,neha...
Can you please help me in this .