How to Capture rejects through Oracle Load Option

chpraveen.msc · Post by **chpraveen.msc** » Fri Sep 07, 2007 5:38 am

Hi All,
In our project, we have a requirement to load millions of records from file to Oracle database. Data volume being quite high. We decided to go for Oracle Load option. We are able to load data through this option (oracle Load utility), but we need to capture rejects as per the client requirements. When ever we made the interface to run, Oracle loader is creating a bad file (containing Reject records) in the Scratch Disk area. Is there any way that we can explicitly specify the path for Bad file.
so that we can get flexibility to mail the Reject file to respective client Departments.
Since we have planned to run many of the DS interfaces using the oracle Load option, all the bad files will be capture in the same path and its becoming complex for us to identify the bad file generated by respective interface.

Thanks in Advance.

ray.wurlod · Post by **ray.wurlod** » Fri Sep 07, 2007 5:49 am

Yes there is. Research the properties of the stage carefully (particularly the available properties to add in each of the properties folder). Report back with your research findings.

You might also Search the forum; I'm fairly sure this has been answered before.

Maveric · Post by **Maveric** » Fri Sep 07, 2007 7:07 am

Ray, I could think of Open, Close command properties and APT_ORACLE_LOAD_OPTIONS. Will these help? Am i on the right path?

chulett · Post by **chulett** » Fri Sep 07, 2007 7:09 am

chpraveen.msc wrote:Is there any way that we can explicitly specify the path for Bad file.

Just the .bad file? I don't believe so, but you should be able to control where all the files are written. I don't recall the exact answer but a search should turn up the APT variable that needs to set.

ray.wurlod · Post by **ray.wurlod** » Fri Sep 07, 2007 3:50 pm

I too am not doing DataStage things this week and operating from memory. But you definitely have control, and the question has been asked and answered in the past. Search.

DSguru2B · Post by **DSguru2B** » Sat Sep 08, 2007 3:36 pm

Checkout csrazdan's reply in this post.

JoshGeorge · Post by **JoshGeorge** » Sat Sep 08, 2007 8:52 pm

APT_ORA_WRITE_FILES will allow you to specify a file (not a directory) from where you can execute sqlldr. The post referred above was later discussed in another thread and clarified.
Pls. find the same HERE

DSguru2B :

Checkout csrazdan's reply in this post.

DSguru2B · Post by **DSguru2B** » Sun Sep 09, 2007 4:23 pm

O yea. THats right. Thanks for the clarification Joshy.

DSXchange

How to Capture rejects through Oracle Load Option

How to Capture rejects through Oracle Load Option

Re: How to Capture rejects through Oracle Load Option