Hello I have a ODBC stage and I charge an Oracle stage. The load is really slow, average 800 rows per second. Since DataStage has some particular settings with Oracle 12, I do not know how to improve this speed anymore.
I have divided the job so that the data is in a sequential file and after transformed they load, but it remains the same.
Any ideas or suggestions?
ORACLE CONNECTOR STAGE IS SLOWER
Moderators: chulett, rschirm, roy
ORACLE CONNECTOR STAGE IS SLOWER
Anguila09
Why the intermediate flat file? If you really want to do that, it should be split into two separate jobs so that you have better restartability. Also don't forget that "rows per second" - besides being a pretty useless metric - counts the entire time your job runs so the first half can make the second half look... slower. Never mind that splitting it will help determine where the actual bottleneck is.
What happens if you replace the sequential file with a transformer? Does the performance change / improve at all? And as Paul notes, the connector does need to be "properly configured" so you'd need to let us know your properties there, how it is currently configured, to be able to provide more specific help. I'd also be curious what your ODBC source is, something other than Oracle?
What happens if you replace the sequential file with a transformer? Does the performance change / improve at all? And as Paul notes, the connector does need to be "properly configured" so you'd need to let us know your properties there, how it is currently configured, to be able to provide more specific help. I'd also be curious what your ODBC source is, something other than Oracle?
-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: