Sql Loader

[Quoted] Hi Guys...
I am loading data from a flat file into a table. Everything is running fine. I receive a file as full refresh or partial refresh. In case of partial refresh only the new records are being send from the last load and so no problem comes. In case of an full refresh, the older records are also send from the last load and so the records get rejected due to PK violations on the table. Till now everything is okay. But what I want is that rather than rejecting the recods due to insert statement I want the record to be updated with the new value. Is there any way in which CTL file can handle INSERT and UPDATES on the table on the same time.
Any suggestions in this regard will be appericiated. If you require more input please send me a mail on csrazdan_at_indiatimes.com

Regards,
Shekhar

--
Posted via http://dbforums.com