AnsweredAssumed Answered

Pentaho Spoon - Dimension lookup/update - update not working

Question asked by Siddharth Vij on Jan 7, 2018
Latest reply on Jan 30, 2018 by Gotn O'Guts

Hi Everyone,

 

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:

IDEmp CodeNameLocationSalaryVersionFromTo
1AB001RamDelhi60001nullnull
2AB002ShyamPune70001nullnull
3AB003MacSan Jose200001nullnull
4AB004RennySan Jose

25000

1nullnull

 

Data coming from stream is given below:

Emp CodeNameLocationSalary
AB01San Jose18000
AB02

8000

 

Expected result:

The row with ID 1 in employee table should have the location and salary updated. The row with ID 2 should have salary updated.

 

Actual result:

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?

Outcomes