Maintaining an SPD Server Cluster

Problem

You want to maintain an existing SPD server cluster by adding a table to a cluster, generating a list of tables that are included in a cluster, or removing a cluster definition.

Solution

You can use the List Cluster Contents transformation or the Remove Cluster transformation. These transformations are explained in the following table.
SPD Server Transformations
Server
Tasks That Require This Server
Add a table to a cluster
Perform the following steps to use the Create or Add to a Cluster transformation:
  1. Create an empty job.
  2. Drop the Create or Add to a Cluster transformation into the Job Editor window.
  3. Replace the temporary output table with the clustered table.
  4. Drag the cursor from the output port of the Create or Add to a Cluster transformation to the input port of the cluster table.
  5. Run the job.
Generate a list of tables in a cluster
Perform the following steps to use the List Cluster Contents transformation:
  1. Create an empty job.
  2. Drop the List Cluster Contents transformation into the Job Editor window.
  3. Drop the cluster table onto the Job Editor window.
  4. Drag the cursor from the output port of the cluster table to the input port of the List Cluster Contents transformation.
  5. Run the job.
Note that you can also include the List Cluster Contents transformation in an SPD server cluster job. This generates a cluster list each time you create a cluster.
Remove a cluster definition
Perform the following steps to use the Remove Cluster transformation:
  1. Create an empty job.
  2. Drop the Remove Cluster transformation into the Job Editor window.
  3. Drop the cluster table into the Job Editor window.
  4. Drag the cursor from the output port of the cluster table to the input port of the Remove Cluster transformation.
  5. Run the job.
The cluster table is now removed and the tables that were in the cluster are now available as individual tables.
Last updated: January 16, 2018