Hi, The table Update step doesn't seem to show an accurate reflection of the number of updates that occurred. Is this by design?
I know the JDBC makes this information available as I get confirmation on the number of updates when using my SQL Client DBeaver.
3 Community Answers
Kalyan Arangam —
I understand this can be misleading. The component provides 3 row counts, we export all of them via variables. None of them really make sense being used as a total on their own, nor does summing them particularly.
I have raised an internal ticket (EMD-5145) to either come-up with a better way of displaying the results or do-away with displaying the total.
If you’d like to make use of the row-counts for some auditing purposes, please export these values into variables and use them appropriately.
I vote for a better way of displaying. People don't want to write their own logging code as it complicates the overall solution, which should be primarily focused on ETL and data transformation not logging and alerting.