Is there any sample workflow available, which performs the operation of inserting the data in IBM DB2 table from the table present in hadoop database.I am first time user of this KNIME platform so exploring some options to leverage KNIME for DB2 related operations.

you could use one of the rename nodes. In general for your scenario you would need some planning. How to know which data has already been transferred. You might need an intermediate table to store such information or check from the target table the IDs or dates that have been transferred.

DB2 Inserts from Hadoop

KNIME Extensions

izaychik63 May 10, 2020, 1:30pm 7

See recommendation here