Problem with Toracleoutput : insert or update option
Hi everyone, I use TOS3 I have a little problem with the component tOracleOutput, my subjob is very simple: tDelimitedFile ----tMap----tOracleOutput----tOracleCommit | tOracleInput
The tOracleOutput and the tOracleInput use the same table on my ORACLE In fact, I want to simply update or insert information from my delimited file. tOracleOutput option "Insert or update" >>> The update work greatly, but i can't insert information, there is no error for TOS, for him all is great, but in my database i didn't receive the new rows. tOracleOutput option "Update" >>> same thing tOracleOutput option "Update or insert" >>> same thing tOracleOutput option "Insert" >>> My table receive all information in double. can you help me to understand?