Topic
  • No replies
SystemAdmin
SystemAdmin
7754 Posts

Pinned topic DRS Connector/Dynamic RDBMS vs Oracle Enterprise

‏2013-03-26T12:10:00Z |
Hi,

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.

Thanks.