You can increase the speed at which a transformation is processed by distributing the records read from the DMSII source database to multiple servers.
To implement this,
Install multiple instances of the DDW, Runtime Administration, and Runtime Service on multiple servers.
Create Transformations in these DDW with the same source database and deploy them to the Administration Site.
After deploying the Transformations, open the SQL Server Management Studio.
Navigate to Databases > UnisysDExchAdminDBversion_no > Tables > dbo.SourceDBs.
Run a query to fetch data from dbo.SourceDBs.
Copy the SourceId of your source database.
Similarly, copy the SourceId of the source database from the other server where you have installed the DDW, Runtime Administration, and Runtime Service .
On the MCP host, open the DATAEXCHANGE/CONFIG file.
Include the SourceIds in this file in the following format:
Scaleout = “source_id” . <no of servers> <selection criteria: the MOD operation result that will determine if the records are included or not. If the remainder of the MOD operation is 0 it goes to that server and if the remainder is 1 it goes to the other server>.
For example:
altaudit = pack
port = 8308
auditflush =1500
Scaleout ="8CC3E631-CE58-4EE1-80B8-FA4901AFB991" 2 0
Scaleout ="03887C52-29D0-4E89-BF2B-A40FD8A22759" 2 1
Save the CONFIG file.
Restart the corresponding MCP Agent.
Start the Transformations on all the servers.
The records are divided among the servers to share the processing.