I have input from Mysql database. I am writing this to Sql Server database.
Along with this, I want to store the following information in a separate table after successful job:
id, load_date, table_name,no_of_records_inserted, no_of_records_updated, no_of_records_rejected.
How can I do this?
Thanks in advance.
Usually, we use Nb_LINE is used to count the total number of records have been proceed.
When this option is set to NONE, there is no a global variable for counting the total number of records have been inserted, updated, or deleted.
When inserted item is choosen, there will be a global variale such as (Integer)globalMap.get("tMSSqlOutput_1_NB_LINE_INSERTED")) will be avaible, which counts the total number of records have been inserted into database.
The same to updated, deleted items
For no_of_records_rejected, you can drag "Rejects" row from your output DB component.
Please see my screenshot for detail