I have a scenario to insert and update database target tables using Dynamic schema. I have tried with Java methods available for Dynamic schema. I can able to define column structures and assign them values, but not the keys. And, db output component is failing with error: “Key must be defined to update”
I think that rather than a single Dynamic Schema column, you can define one column (the primary key) and then the additional Dynamic Schema column (minus) the Primary key column. Then you can define it as the the Key and the Insert/Update should work as expected.
