Problem with Toracleoutput : insert or update option

Anonymous — Sat, 16 Nov 2024 13:39:18 GMT

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?

topic Problem with Toracleoutput : insert or update option in Talend Studio

Problem with Toracleoutput : insert or update option