How to count number of rows affected (created/updated) by tMySQLSCD..?
Is there a way to know the number of rows that an SCD component (::such as tMySQLSCD) affects? (::affect meaning updates and/or creates) I tried to put a 'tFlowMeter' after a tMySQLSCD, but that doesn't work since the tMySQLSCD does not output a Main Row. Thanks and cheers! -Enrique
Re: How to count number of rows affected (created/updated) by tMySQLSCD..?
Hi, There should be two variable available after the component runs: NB_LINE_UPDATED and NB_LINE_INSERTED accessible through ((Integer)globalMap.get("tMySqlSCDOutput_1_NB_LINE_INSERTED")) Hope this helps. Regards, Arno