I am trying to replicate an existing Informatica Mapping into Streamsets.
I selected JDBC Consumer to compare staging table with target table for identifying and separating the records for update and insert into target table.
The existing mapping is using an Update Strategy Transformation (Informatica) to perform an update on Target Table based upon the received update records.
I am trying to achieve the above functionality in StreamSets to perform an update on target table.
Please share your inputs.
Attached screen shot for reference.