At the start of a Subset run the row counts from the source and target table are counted in order to give an insight into how much effect a run has had. I.e. if the source table had 1,200,000 rows, and the target table now has 12,000 we can deduce that the final ratio is 10%. This is a process that takes some time at the start of a run. Is it possible to turn this off in order to make runs execute faster?


In Subset it’s not possible to turn this off, however if the Subset package has been imported into Runtime you can. The reason we’ve decided to seperate it this way is because usually when developing a template knowing how much a dataset is being subsetted is important for knowing whether the desired results are being reached. However, once a template has been implemented in Runtime we can safely assume that a run will perform according to expectations, and this overhead can be removed.

To do this, follow these steps:

Runtime → Groups → Environment → Settings → Disable DPF_COUNT_SOURCE_TABLES and DPF_COUNT_TARGET_TABLES