we have faced the problem with the CLOB fields transfer from Oracle to IBM DataStage. On the forums we saw recommendations to use DRS Connector / Dynamic RDBMS instead of Oracle Enterprise. This solution looks good for the small tests.
However it is not clear for us, what are the disadvantages of using DRS Connector / Dynamic RDBMS. Would be there any performance issues and other stuff? Should we find some other solution or is it ok to use DRS Connector / Dynamic RDBMS?
We are using IBM InfoSphere Datastage 8.5 and Oracle 10g Enterprise Edition. There would be a simple query running on the history table which could have billions of records.