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.
How to Capture rejects through Oracle Load Option
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 26
- Joined: Tue Nov 08, 2005 5:36 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
You might also Search the forum; I'm fairly sure this has been answered before.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: How to Capture rejects through Oracle Load Option
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.chpraveen.msc wrote:Is there any way that we can explicitly specify the path for Bad file.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
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
Pls. find the same HERE
DSguru2B :
Checkout csrazdan's reply in this post.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>