slow performance with Oracle CLOB field
Posted: Wed Apr 02, 2014 7:14 am
Hi,
I have a EBCDIC file and in that file i have different record indicators.
The last fields in file contains sub-columns ie., the meta data of the last field varies based on the record indicators.
Designed a job
Sequential file (with last column defined as VarBinary) --> Transformer ---> Load data to the Oracle table (the last field is CLOB data type in Oracle and defined as Varbinary in Datastage)
Its taking hours together to execute the job.
Array Size is sett to "1" in oracle connector.
Can you anyone help to improve performance of the job.
I have a EBCDIC file and in that file i have different record indicators.
The last fields in file contains sub-columns ie., the meta data of the last field varies based on the record indicators.
Designed a job
Sequential file (with last column defined as VarBinary) --> Transformer ---> Load data to the Oracle table (the last field is CLOB data type in Oracle and defined as Varbinary in Datastage)
Its taking hours together to execute the job.
Array Size is sett to "1" in oracle connector.
Can you anyone help to improve performance of the job.