DSXchange

Hmmm... I tried the DS7.0 ORAOCI Bulk Load stage using "Load Mode = Manual" so that it would just generate the CTL and DAT file. It processed a 260,000 row file (500 bytes wide) at 6,000 rows/sec. Processing the same file to a sequential file stage ran at 29,000 rows/sec. At face value it ...

I hear what you're saying. However, the PDF doco makes this version sound a little more s*xy so I am curious. If I had access to a working database I'd be able to give some results rather than bother everyone with these questions.

Ta,
C.

Thanks for your reply Ken, What you say is how I've understood previous versions of the bulk load stage to work. In fact I have only ever previously used the ORA bulk load stages to prove that it's faster to create the .DAT file manually via a sequential file stage! The version of the "ORAOCI B...

Hi, We're using DS7.0 on HPUX. We installed all plug-ins at install time. The properties of the "Oracle OCI Load" stage type when viewed in DS Manager are: Short description: Oracle 8.1 Bulk Loader Long description: Bulk loading Oracle databases using Oracle OCI 8.1 I've read the oraocibl....

Excellent reply. Thanks Vincent.

Hi, We're starting a new data migration project using DS7. The project has a requirement to enforce version control. I'm keen to use DataStage Version Control that ships with DS7 (as opposed to using 3rd party version control software). I've read the help file and set up a few dummy projects to test...