How to avoid duplication in database if we are adding data from .dat file ?

Questions by anilkumarnani

Showing Answers 1 - 2 of 2 Answers

aytasirs

  • Nov 15th, 2012
 

There is no option to avoid duplicates when inserting data from flatfiles using sql*loader.

The best way is load the data into staging table and write the
query to eliminate the duplicate rows.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions