DSXchange

We are encountering a weird issue with the Oracle Load option in the Oracle EE stage. If we use this option with Sequential Files or Datasets as input, the LOAD option works. It we use an Oracle EE stage as input and an Oracle EE stage as output, no data get loaded. The log shows the number of records being exported but after reviewing the XXXX.ora file, no records are written and no error produced.

I opened a PMR with IBM and they produced a patch but it still doesn't work. Has anyone else encountered this issue and if so, did you find a solution.

If we use the upsert, everything is fine. In some cases, we would like to use the LOAD.

Thanks in advance.

Do you know what the patch addressed - that would be where I'd start looking.

Have you tried DIRECT=FALSE option?

Yes, tried a number of different options. Even tried it on version 8.0.1. We have both versions. Still trying to determine why. What's very strange is, I can't find the ctl file or the fifo.out file.

Did you try including a copy stage with force option or probably a transformer ?

Is there any Reference available in your target table?
Have you tried to load those records to a temp table?