I am having a flat file with 10 records, and out of it 5 records are duplicate records (unique key column: Customer_Id
and source_system
). This flat file has to load to a Oracle table and this is the first load.
How can I eliminate the duplicates in it?
There are quite a few ways to handle this: