Hi ,
I am using oracle load method to load 140 million records.
a) Is there any way i can get the rejected records from the oracle enterprise stage?
b) To improve the performance what are all the things i have to take care
thanks and regards,
MCH
Oracle Load Rejects
Moderators: chulett, rschirm, roy
Oracle Load Rejects
harshakumar mc
If you draw a link from your Oracle stage and change the Oracle stage settings then all rejects will go down that link.
There are so many factors affecting throughput that the second question is not easily answered, it is like asking "how can I make my car faster?" and expecting a concise response.
Usually most of the factors affecting throughput are changed on the database side, not just the DataStage side.
There are so many factors affecting throughput that the second question is not easily answered, it is like asking "how can I make my car faster?" and expecting a concise response.
Usually most of the factors affecting throughput are changed on the database side, not just the DataStage side.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Oracle Load reject records
Hi ArndW,
Thanks for replay...
Can you please explain me bit more collecting reject records from oracle load method?
thanks and regards
MCH
Thanks for replay...
Can you please explain me bit more collecting reject records from oracle load method?
thanks and regards
MCH
harshakumar mc
I could try to explain, but could not come close to the numerous detailed descriptions in the Parallel Job Developer's Guide. The documentation details reject handling for all stages that support this output.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 48
- Joined: Wed Jun 01, 2005 7:10 am
Hi Harsha,
You can capture the reject records while you use the oracle load method. The rejected records while loading the data into the table gets saved in the scratch disk with the control file,log file and thebad file. The bad file is the bad data which failed to load the table.
Once you use the load method, the job aborts if the data is rejected,to catch all the rejected records then you need to use the APT_ORACLE_LOAD_OPTIONS properly to get all rejected records. Once the job completed(aborted), you should get the control,log and bad file from the scratch and place it into the different path.
You can capture the reject records while you use the oracle load method. The rejected records while loading the data into the table gets saved in the scratch disk with the control file,log file and thebad file. The bad file is the bad data which failed to load the table.
Once you use the load method, the job aborts if the data is rejected,to catch all the rejected records then you need to use the APT_ORACLE_LOAD_OPTIONS properly to get all rejected records. Once the job completed(aborted), you should get the control,log and bad file from the scratch and place it into the different path.