One Star

[resolved] tOracleOutput with Where clause

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.
1 ACCEPTED SOLUTION

Accepted Solutions
Seventeen Stars

Re: [resolved] tOracleOutput with Where clause

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.
3 REPLIES
Seventeen Stars

Re: [resolved] tOracleOutput with Where clause

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.
One Star

Re: [resolved] tOracleOutput with Where clause

Yeah, thank you it works!
One Star

Re: [resolved] tOracleOutput with Where clause

Could you post an image of that, i don't understood