• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Problem with Toracleoutput : insert or update option

#1 2009-12-08 11:32:02

xanass
New member
Registered: 2009-12-08
Posts: 1

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?

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Problem with Toracleoutput : insert or update option

Board footer

Powered by FluxBB