databasepentahoinsert-updatepdi

How to get rows which are inserted/updated only in Insert/Update step in Pentaho?


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?

logging after Insert/Update step logging


Solution

  • 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

    enter image description here