topic Re: [resolved] tOracleOutput with Where clause in Talend Studio

[resolved] tOracleOutput with Where clause

Anonymous — Thu, 14 Mar 2013 16:52:53 GMT

Hi,
I have a problem with the tOracleOutput Element, before the data should be update or insert in the database, I only want to update data of the outputdatabase which fulfils a where clause.
Right now I just solve this probleme by joining the new and old data which fulfils the where clause and than update the outputdatabase. The problem is the performance is really weak, have you any Ideas how I can accomplish this better?
Job Design:
tOracleInput ->
tMap -> tOracleOutput
tOracleInput ->
Thanks for your help.

Re: [resolved] tOracleOutput with Where clause

Anonymous — Thu, 14 Mar 2013 20:58:59 GMT

Yes you can use tOracleRow to do that.
You have to specify your update statement (with your needed where clause) as a prepared statement and in the advanced section you can bind your flow columns to the prepared statement parameters.

Re: [resolved] tOracleOutput with Where clause

Anonymous — Fri, 15 Mar 2013 14:42:41 GMT

Yeah, thank you it works!