I'm using Pentaho to insert/update rows to a table with the Insert/Update step
. The problem is I want to know which rows are inserted or updated into my table.
But when I try to create a Log step
after the Insert/Update step
, it just logs all the rows from the stream no matter if they've existed in the table or newly inserted/updated.
Is there any way to take the rows that are inserted/updated to a table only in the Insert/Update step
?
Using Insert/Update step, its not possible to know "which rows are inserted or updated". But you can use an alternate way to perform insert and update action ; and also know the log status. You can found sample transformation from Here