DSXchange

I havent used it to create two datafiles. I can try this. I have plenty of workarounds. The reason that stage is used is a historical one that I dont know. It is used a lot elsewhere in the warehouse as well even though it is a 9i DB that gets written to. This problem has only started happening rece...

The datafile and control file are created but if falls over during population of the datafile. It isnt an oracle issue as it doesnt seem to get to the point where it calls SQLLDR i.e the error comes from the transform stage.

ArndW wrote:At Version 7.1 there is an automatic/manual option.(I have my 7.1 designer open at the screen that has it...)

Not on the Oracle 7 Loader in the version that I have there isnt.
In manager:
The stage name is Oracle 7 Loader, description is Bulk Loader the version is 1.0.0.

Datastage Version is 7.1.
It is the older ORA_BULK type stage so there is no manual or automatic option.

The dump is coming from the Transform stage, not the bulk load stage. If you put a constraint "1=2" in the transform so that no rows are passed to the ORA passive stage does the error still occur? No it doesnt. It only occurs with large amounts of records. I can pass smaller result sets with no pro...

Hi, When I write + 1 million records to an Oracle Bulk stage it falls over with the following error codes. I doesnt get to the point where it kicks off sqlldr. Has anybody come across this ? From previous run DataStage Job 47 Phantom 6582 jobnotify: Unknown error DataStage Phantom Finished. [6593] D...