CODEWITHSUNDEEP
real-timetalend
OthmenR
OthmenR

Reputation: 1

Updating values in real time Talend

I'm trying to update my data with talend.I'm using tOracleOutput with the option 'update or insert' but my problem is that when there is an update i want to sum the older and the newer value of a row because my app is executing in real time.There is any help? (sorry for my bad english)

Upvotes: 0

Views: 463

Answers (1)

dbh
dbh

Reputation: 1627

You can use a tOracleRow component containing a SQL update statement . Take the new value (from context, row, or globalMap) and use that in the update statement within tOracleRow, adding it to the existing value of the desired record.

Ex " UPDATE target_table SET target_field = target_field " + globalMap.get("newVal") + " WHERE target_id = " + globalMap.get("id") + " "

Upvotes: 1

Related Questions