oracle - ODI mappings - Update column in table

Question

Hope this is a easy answer for a Oracle specialist :)

Working with Oracle database. I′m creating a mapping in ODI studio 12c. Want to update a column in one table.

A simple SQL (Microsoft) would be :

Update t1
SET t1.column = t2.value
FROM table t1
JOIN table t2 on t2.key = t1.key

How can I do this in ODI mapping?

Looking at the Integration Knowledge modules there is a : "IKM Oracle Update.GLOBAL"

But when applying it to the mapping my simulation does a merge statement, which is not doing the UPDATE I am trying to do.

Answer 1

等待大神答复