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

dddn — Fri, 15 Nov 2024 21:49:35 GMT

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

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

Anonymous — Tue, 16 May 2023 06:47:52 GMT

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

Regards

Shong

topic Re: How to update a specific column field from a dynamic column without updating all other column fields, using tdb_output? in Talend Studio

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

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