Page 1 of 1
where to use bad files in orabulk load stage properties.
Posted: Wed Apr 07, 2004 11:53 pm
by Gughanand
I tired using to connect the orabulk load stage for transferring the 10lakhs rows for source to target.But i couldn't find the bad files / rejected files in orabulk stage properties.Kindly help me in this ...I should meet my deadline....
Posted: Thu Apr 08, 2004 12:39 am
by ray.wurlod
Welcome aboard! :D
The ORABULK stage is quite old, and quite limited in the functionality and performance it offers. 10,00,000 rows is what DataStage practitioners would regard as a medium sized ETL task.
Search this forum to find techniques to gain orders of magnitude more speed using a Sequential File stage to write the data file(s), and the ORABULK stage to write the control file for sqlldr.
There is a lot more that you can do, by editing the control file before invoking sqlldr, such as tuning the buffer sizes, specifying parallel load and, as you want to do, specifying a destination for the bad rows.
None of this is automatic, however.
