loading with external table rejected records not written to bad or discard file [message #403272] |
Thu, 14 May 2009 10:02  |
ndahafa
Messages: 16 Registered: November 2006
|
Junior Member |
|
|
I am loading data from flat files using external tables. I have a primary key on my target table and understandably records that violate the primary key constraint get rejected.
The problem is: If the flat file contains a mixture of records that already exist and records that don't exist in the target table, none of the records in that file get loaded and this is understandable (found an explanation at http://www.gennick.com/ETLandBad.html)
However no bad file or discard file is created so that I can go back to trace those records and insert them in the target table using another way.
please help me find a solution
|
|
|
|
|
Re: loading with external table rejected records not written to bad or discard file [message #403280 is a reply to message #403276] |
Thu, 14 May 2009 10:20   |
ndahafa
Messages: 16 Registered: November 2006
|
Junior Member |
|
|
hi Michel,
since a file can be rejected altogether as long as it contains some 'bad' records, I want to be able to go back to such a file so that I can get the 'good' records and load them into the target table.
external tables does not write those records to a bad file or discard file so I have no way of knowing that there were in fact some 'good' records in the file.
i hope this is clearer
|
|
|
|
|