My system Details:
DataStage server 7.5.3
OS:Solaris
Oracle 10g
My Issue:
I have four primary keys, datatype of one is varchar2 others are numeric in my table, Table has been indexed
When i go for insert using the Oracle enterprise stage. i am able to get performance of 4570rows/sec
In Same table, When i go for Update using the Oracle enterprise stage. i am able to get performance of only 200rows/sec or even low
If i change my varchar2 key data type to numeric and then if i go for update. i am able to get the performance of 4125/sec
Note: To the same table using ODBC stage from server jobs, i am able to get better performance without changing the keys data type, for update action
My jobs are supposed to be in parallel. So help me out to resolve this issue.
![Sad :(](./images/smilies/icon_sad.gif)