Hi Tony,

Thank you for your input. My simple objective is that I want to transform the data later (by schedule) and not immediately when a web service place data in import set table. But, the problem is data is transformed immediately when web service place it in import set table.

The only reason why I am willing to do this is because we have some very big imports which includes nearly 1000 records for one of dictionary table. And, many times part of the import set data remained unprocessed (Pending state) e.g. 300 or 400 etc. This is because of the transaction time limit. Therefore, I just come up with a thought to place the data only in import set table and set it into "Asynchronous" mode using let's say a BR script and then schedule running the transform map later at a specific time.

I believe, I am able to explain my scenario well. Let me know if you have any suggestion to achieve it.

Hope to hear from you!

Brgds, AM