Hi,
In a transformer stage, I have two output links. One writing to a hash file(link1) and another to update a table(link2).
I want to update the table with the number of records written to link1 in the transformer. I want to do this after all
the records are written to the link1. Any ideas how I can accompilsh this ?
thanks,
nrc
number of records written to a link
Moderators: chulett, rschirm, roy
Run your second link to an aggregator first and then to the update. Send a numeric field set to 1 for every row that goes down the first link or a 0 for any rows that don't... either that or have them use the same constraint. Then just do a 'sum' in the aggregator.
If there are no constraints involved you can also send @OUTROWNUM down it and let the aggregator take the 'Last' or 'Max' value.
If there are no constraints involved you can also send @OUTROWNUM down it and let the aggregator take the 'Last' or 'Max' value.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers