Sure and you are... it's just that it is not a very performant option to pull data from the source across the network into DataStage and then push it back out to the target, one record at a time. Perhaps your DBA could suggest an alternate path - dump the contents, move the output file to the other server and then import via sqlldr?
-craig
"You can never have too many knives" -- Logan Nine Fingers
There are 2 tables - one has CLOB and the other has BLOB datatypes. As Datastage data type for LOB are LongVarChar or LongVarBinary respectively. I haven't defined a size to these fields in the job.
Are there any alternate stage or any properties using which I can improve the upsert performance.
And adding in the fact that you are source a CLOB and targeting a BLOB (or even if vice versa) reinforces my advice to use another tool for this. At least it reinforces it in my mind.
-craig
"You can never have too many knives" -- Logan Nine Fingers