This article explains how to use Statistics delivered by the execution of a mapping in the process that contains this mapping.
Process overview :
The Load Address mapping loads data from a table to another one.
In the process, Action 1 will be executed if rows have been inserted into the target table in the previous Load Address mapping and Action 2 will be executed if no row has been inserted into the target table in the previous Load Address mapping.
To know if rows have been inserted into the target table or not, we can consult the Statistics variables, updated when executing a mapping and especially, SQL_STAT_INSERT.
They can be consulted from the Statistic view :
We can recover these variables in the process and use it to create a condition of a link.
The syntax to access the value of a statistic variable is the following :
__ctx__.sumVariable("Variable name","Mapping name")
In our example, we test if the SQL_STAT_INSERT variable, returned by the Load Address mapping is greated than 0.