Capturing Records Rejected due to Load Option
Posted: Wed Apr 25, 2007 12:41 am
Hi,
I am loading records into my 26 staging table using Load /Append option. The source for all the staging tables is their respective datasets and my taget is Oracle. For some of the staging tables all the records don't get inserted into the target table where as the Performance statistics shows that the all the reocrds got loaded and also their are no errors in the log. But when i go to the folder where the sql loader logs gets generated it tells me the exact reason why the records got rejected. Since i am using the load/append option i can't have the reject link.
I want that if for any table a bad sql loader log file is generated it should send a warining mail to the ETL Team. For all these 26 tables the log files gets generated in to folder ds01 & ds02 as i have a two node file. But by just looking at the names of these log files i can't make out which log files belongs to which Staging Table untill i open it. Is there any way that i can capture the corresponding names of the log files and generate a warning mail.
Thanks
I am loading records into my 26 staging table using Load /Append option. The source for all the staging tables is their respective datasets and my taget is Oracle. For some of the staging tables all the records don't get inserted into the target table where as the Performance statistics shows that the all the reocrds got loaded and also their are no errors in the log. But when i go to the folder where the sql loader logs gets generated it tells me the exact reason why the records got rejected. Since i am using the load/append option i can't have the reject link.
I want that if for any table a bad sql loader log file is generated it should send a warining mail to the ETL Team. For all these 26 tables the log files gets generated in to folder ds01 & ds02 as i have a two node file. But by just looking at the names of these log files i can't make out which log files belongs to which Staging Table untill i open it. Is there any way that i can capture the corresponding names of the log files and generate a warning mail.
Thanks