In tOracleOutput, for delete/update action, we need to select delete/update key columns. it worked well when all key columns are not null. But if one of the column is null, it does not work as (I) expected.
For example, I have a table with 3 columns, (key1, key2, value). column key1 is not nullable, while key2 is nullable. On update , the job will check on the key columns to see if they are the same. I hope, (source.key1 =1, source.key2=null), will match with (target.key1=1, target.key2=null), so the target.value is updated. But from my testing, target row is not updated.
Any suggestion to make this happen?