To increase performance when running a session on a grid with Sequence Generator transformations, increase the number of cached values to one number for each row of data. This reduces the communication between the master and worker DTM processes and the repository. The master and worker DTMs communicate once for each cached value.

For example, you have 150,000 rows of data and seven Sequence Generator transformations. The number of cached values is 10. The master and worker DTM communicate 15,000 times. If you increase the number of cached values to 15,000, the master and worker DTM communicate ten times.