Obtaining number of rows written to multiple targets in Informatica Power Center

Question

I have a requirement where I need to obtain the number of rows written to multiple targets in my mapping. There are 3 targets in my mapping (T1, T2 and T3). I need the number of rows written to each target separately. These values need to be used in subsequent sessions. I understand that there is a method where I can use separate counters and write them to a flat file and perform a lookup on this file in subsequent mappings. However, I am looking for a direct and better approach to this problem.

Answer 1

You can use the $PMTargetName@numAffectedRows built-in variables. In your case it would be something like

$PMT1@numAffectedRows
$PMT2@numAffectedRows
$PMT3@numAffectedRows