How to update a specific column field from a dynamic column without updating all other column fields, using tdb_output?

[dddn]

Hi, I have a dynamic column which I want to load into target database, before loading I want to update the field FLAG to null, this means that for a records which exist in the target in source we want to update this FLAG column with null when the new records will come from source. So when we have a new record with the same key already existing in target the new record with updated columns with be inserted and the old record with set the column FLAG equal to NULL.

I am using the tdb_output, but when I set the advance properties It will update all columns of dynamic column with the newest data.

Thanks

[Anonymous]

Hi

Can you share a screenshot of the schema of tDBOutput component? newColumn is a filed with 'Dynamic' type?

Regards

Shong