topic Re: Simple update through talend in Talend Studio

Simple update through talend

Anonymous — Tue, 23 Apr 2019 20:26:52 GMT

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?

Re: Simple update through talend

akumar2301 — Tue, 23 Apr 2019 20:51:45 GMT

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

Re: Simple update through talend

Anonymous — Tue, 23 Apr 2019 20:56:08 GMT

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

Re: Simple update through talend

manodwhb — Wed, 24 Apr 2019 05:29:26 GMT

@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 .