Simple update through talend

[Anonymous]

Hi Experts,

I just wanted to copy column operation using simple update.

e.g UPDATE TAB SET C1= C2 

Wanted achieve this through talend component. Table has huge volume of data. So will not update through tOracleRow (wanted to update row by row with commit size). 

Is it possible to update through tOracleOutput without where clause?

[akumar2301]

To use toracleoutput , you have to use toracleinput with

“Select c2,keycol1,keycol2.. from TAB”

And then update.

If you donot want to read and write ,

In toraclerow , try

Update TAB SET C1=c2 where C1!=C2

Or you can write simple bulk update procedure in oracle

[Anonymous]

How will i update through tOracleoutput  as table doesn't have key column.

[manodwhb]

@senthilswing ,since voulme is huge, that to this is simple update,i will suggest you to create a stored procedure and call that in Talend using tOracleSP component .