You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2016-11-11 21:23:09

hjiang
Member
17 posts

hjiang said:

[resolved] handle null key column

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?

Offline

#2 2016-11-15 15:22:17

hjiang
Member
17 posts

hjiang said:

Re: [resolved] handle null key column

Thanks to cterenzi This is resolved as in topic  "Handle null value in key columns."

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy