DSXchange

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

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

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.

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

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

/var/dstage/Ascential/DataStage/Scratch

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.