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.


Solution :


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.