I have already confiigured RDBMS interface to read data from a SQL DB using the distribution tag approach. I am interested to detect instances when not all the rows queried, are not distributed.
Based on the user guide, I can use the @rows_dropped variable for that. However, there are no details about this variable. I am not sure if it is a SQL variable or PI variable?
I am also wondering if I can reference this variable in AF. I am thinking of using this variable to trigger an AF event. is that doable or is there an alternate approach for that?
Thanks in advance,