Thanks florentlb
The use case is like this - The TW is reading a list of recipients from one custom schema(TCD) and processing writing a selected list of recipients into another custom schema(CCL). While it is doing so, the list of recipients that are writing to CCL, there is another schema that needs to maintain the recency (or Last Touch) for these selected users. We need this to compare with a matrix that has the days that any user's will not be contacted based on business rules. The Matrix has data for the recency I.e If a user was contacted for Campaign type A in last 5 days , he may not be contacted for Campaign type B for 5 days and for campaign type C for 10 days.
So we don't want the LastTouch table to be 'dirty' or in process of being updated when the second campaign picks it up. In other words, the campaign type that needs to run, should have the intelligence to WAIT till any other campaigns based on the same template that are ahead in QUEUE to be finished writing to that LastTouch schema table.
Please note that the Campaign type A,B, C, etc are all built from same campaign template.
I hope I am able to describe the requirement for a new person to understand.
/Regards
Kanwal