I was trying the update functionality of Dimension lookup/update component of Pentaho Spoon.
The detailed scenario is given below.
Contents of employee table are given below:
Data coming from stream is given below:
The row with ID 1 in employee table should have the location and salary updated. The row with ID 2 should have salary updated.
Instead of update, there are 3 new rows getting inserted.
I have also attached screenshots of the dimension lookup step.
Can you please help in understanding what am i doing wrong and how can i get the rows to be updated instead of new rows getting inserted?