Capture rejects in Oracle Enterprise with load option?

sattibabu_2004 · Post by **sattibabu_2004** » Tue Dec 19, 2006 10:13 am

Hi,
How to capture rejects from Oracle enterprise stage with load option used? I mean, toc apture in to plain text file? Than k you.

Sattibabu

johnthomas · Post by **johnthomas** » Tue Dec 19, 2006 10:47 am

I dont think you can have a reject link Oracle enterprise stage with load option . Try to create a reject link, it will say that it cannot create it because of lack of "output reject records property".You can always look into scratch directory to find why the data was not loaded

ray.wurlod · Post by **ray.wurlod** » Tue Dec 19, 2006 2:41 pm

The Load option is going to use sqlldr, so you will be able to look in the "log" and "bad" files generated by the bulk loader utility.

sattibabu_2004 · Post by **sattibabu_2004** » Tue Dec 19, 2006 3:43 pm

ray.wurlod wrote:The Load option is going to use sqlldr, so you will be able to look in the "log" and "bad" files generated by the bulk loader utility. ...

In case of Oracle Enterprise stage in PX job, any parameter at server level to setup to tell sqlldr where to write bad files? What is the default log and bad files location? Thank you.

sattibabu

johnthomas · Post by **johnthomas** » Tue Dec 19, 2006 3:49 pm

please look into this directory where sqlldr log is stored .This is the
default directory

/var/dstage/Ascential/DataStage/Scratch

vmcburney · Post by **vmcburney** » Tue Dec 19, 2006 6:40 pm

DataStage doesn't really know whether the load command worked or failed (in terms of number of rows loaded). You could write a DataStage Routine that opens the log file and parses it for success and failure message for use in log messages and Sequence job triggering.