[resolved] tOracleOutput with Where clause

[Anonymous]

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.

[Anonymous · Accepted solution]

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.

[Anonymous]

Yeah, thank you it works!