topic Re: [resolved] After Job Update SQL In Talend Jobs in Talend Studio

[resolved] After Job Update SQL In Talend Jobs

Anonymous — Fri, 01 Aug 2014 01:15:59 GMT

Hi Gurus,
I have a Talend job that loads into a Oracle Table 'XYZ'. Once the job completes loading, I want to run a small update SQL on the same XYZ table.
I do not want to create a Store Procedure for this small update SQL. So is there anyway we can run SQL's in the same job as a after job trigger?
Thanks in advance,
Raj

Re: [resolved] After Job Update SQL In Talend Jobs

Anonymous — Fri, 01 Aug 2014 09:05:20 GMT

Hi Raj,
You can use txxxRow component with OnSubJobOk link from your job, this should do the work... Use whatever update query you have inside this txxxRow component.
Vaibhav

Re: [resolved] After Job Update SQL In Talend Jobs

Anonymous — Mon, 18 Aug 2014 20:09:07 GMT

Thank you, tOracleRow worked for me. Appreciate your help.